delete duplicates from a duplicate querey

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

Guest

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