Duplicates

[Chris]

I need to run labels and reports for a DB w/ several
duplicates (speaker names) in it. How can I run the report
or labels w/o having dupes and w/o deleting them?

 

[Larry Linson]

Use a Query with Unique Values specified. In the Query Builder, right click
on the upper part, choose Properties, then set Unique Values or Unique
Records and try the Query. Then use that Query as the Record Source for the
Reports.

Larry Linson
Microsoft Access MVP