duplicates in a query, filtering

[action]

What is the simple way of removing duplicate query results where the query has returned the same record because the record is in two of the set criteria. I want to create a mailing list but send one letter even if they show twice. I have tried using first in the totals but this just creates a conflict in the query.

Suggestions welcomed. Cheers

 

[WayneRyan]

action,

You can use the Distinct command to ensure that there will
be no duplicates in your query.

Wayne