View Full Version : duplicate records


Cliff
05-29-2002, 06:50 AM
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
05-29-2002, 07:33 AM
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