Hello...

I have a database where the customer name, address, ID, etc. is
unique, however they can be related to several different tables.

For example: Jane Doe is a customer who belongs to several different
committees.

The problem is when creating labels for multiple committees Jane Doe
shows up multiple times. I have used the delete duplicates function,
however since the name is not really a duplicate I am unable to make
this happen.

I hope this makes sense to someone.

Thanks for your anticipated help.

Trish wrote:

You might add the word DISTINCT to the SQL statment. Right click in the
query builder, select Properties, and set UniqueValues to True.

You could even make it a Totals query GROUP BY on the name.