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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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>
 
Back
Top