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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting duplicate records obtained from a duplicate query 4
remove duplicate records in Access 2007 7
Combine Duplicates in Query 0
Query to duplicate a record with one field updated 0
Deleting duplicate records 3
duplicates query 2
Duplicate Query based on two duplicates 7
Delete duplicate records 17

Back
Top