Query to find duplicate records

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I have a table with about 10 fields. Sometime, user input duplicate records.
I would like to create a query or macro to find the duplicate records based
on same information on all the fields, then either copy those to another
table or delete them.
Thanks for any help.
 
Cam

Start at the Database window.

Click the <NEW> button's drop-down and select Query.

Select "Duplicates" in the query wizard window that opens. It will walk you
through the process.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top