Delete Duplicates in a table

  • Thread starter Thread starter Steve Welman
  • Start date Start date
S

Steve Welman

Hi

I have a table of about 200000 records, when I run a find duplicates query,
I get about 3000 results. All these results show that there are 2 identical
records.

How do I now go and delete only one of the entries that is duplicated, not
both records?

Thanks in advance

Steve Welman.
 
Steve

Backup your database.

One approach would be to create a new (empty) table with the same
definition. Modify the definition by adding an index on the field(s) that
uniquely identify the rows. Create an append query from the old to the new.
It will fail when you hit a "duplicate".

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top