Delete Duplicate Records From Large Table?

  • Thread starter Thread starter Henry Smith
  • Start date Start date
H

Henry Smith

Access 2003. Have a large table of data with 32 fields without a key field.
Table has no primary key because it is the repository of a financial data
download. There is a potential of having duplicate records in spite of the
many safe guards incorporated into the program. Looking for a way to test
for and delete duplicate records. Any suggestions and help will be greatly
appreciated.
 
Create a group query - grouped on all fields if they are really exact
duplicates - and count the number of records. If it's more than one then
delete. (...without playing with it, I don't know if you may need to use an
Nz function in there to look after null values...)

Couple of possibilities - only group by 'keyish' fields if they're not exact
duplicates, and display the list of records found to allow a user to decide
whether they really are duplicates.
 
Back
Top