Query to find duplicate records

[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.

 

[Jeff Boyce]

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