delete duplicates from a duplicate querey

A

ArnoldJ

I have many duplicates in a table after running a duplicate querey. I want
Access to tell me how to delete just the duplicate rows.
 
N

Nikos Yannacopoulos

Arnold,

It is actually easier to use a Select query on the table and activate
Totals so you get unique records only, change that into a Make Table
query and produce a new table without duplicates, then get rid of the
original one and rename the new one to the original name.

Tip: back up before you try anything!

HTH,
Nikos
 
Top