removing all duplicated records

[Benny]

I need to find duplicate records and remove them all. I need to leave the
single entry records only. I have been able to isolate the duplicated
records, but I can not remove them. It will let me remove some of the
records but not all of them.

 

[Jerry Whittle]

One method is to return just one copy of the duplicate records by using a
DISTINCT clause in a SQL statement, or use a Totals query where every field
is Group By'ed. Convert this query to a Make Table query and create a table
with just these records. Next delete all the records in the original table.
Lastly use an Append query to pour all the records from the new table back to
the old.

There are problems with this if the table involved is linked to other tables
in the Relationships Window with Referiential Integrity enabled or even just
informal links between tables.

As always, make a complete backup of the database before doing such drastic
changes in the tables.