How can I creat an Access query to find duplicate records?

K

KH

I have a mailing list of 10,000 records and I want to find any duplicate
addresses so we don't mail them twice. Can this be done with an Access
query? I am using Access 2003 on XP professional.
 
J

Jeff Boyce

Create a query that includes the fields that may be duplicated. Change the
Unique Values property to "Yes". You should get only one of each.

Jeff Boyce
<Access MVP>
 
Top