duplicate records

[Cliff]

I'm running a query that returns records containing duplicate client names. I want to mail merge the results and only need one record for each client. Is there a way to limit the return to only one record per client? HELP?

 

[Howlsta]

Cliff,

Depending on the design of your table - changing the queries properties may work. Right click and select properties and change unique values to "Yes".

HTH

Rich