Duplicates Removed 1

[Olddogg]

I have a Query that I am using then I plan to mail merge the fields into word.

The problem is there is duplicates coming out of the query and I do not want to waste a bunch of labels/paper.

Is there any way to filter out duplicate records in a query?

Do I have to redesign the query?

Thank you Very much.

Jon

 

[PHV]

Have you tried the DISTINCT predicate ?
SELECT DISTINCT ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886