Deleting Duplicates

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

In Access 2003 After running the duplicate query finding all the duplicates
how would I go about deleting them leaving one record.
 
If you have only a few duplicates, you can copy paste the ID's of the
duplicate records into excel or notepad and delete them from the table
manually.
If you get any messages about not being able to delete a record because
there are related records in another table, then you will have to delete the
related record first.

If you have hundreds of records to delete, you will need to build a delete
query. That may or may not be easy depending on the relationships between
the tables.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
In Access 2003 After running the duplicate query finding all the duplicates
how would I go about deleting them leaving one record.
Click to expand...

How do you want to choose WHICH record to delete and which to keep? Does it
matter?

If it doesn't, consider creating a new empty table with the same structure as
this one (copy and paste the table, choose "Design View Only"); create a
unique Index on the combination of fields which identify a duplicate; and run
an Append query to append data from your current table into the new one.
You'll get a warning message that "x records were not inserted due to key
violations" - those are the duplicates being lost forever.
 
Back
Top