How to delete duplicate records

[DaniBoy]

Hello,

I have a table that has many duplicate records. I tried importing the table and setting the field to no duplicates but did not work. How can I delete duplicate records. The primary Id id fine I have another field that I can use. it is a BAC number that is repeated many times. Here is the table I need fixed.

Thanks

 

[neileg]

If you create a new, empty table and set the ID field to no duplicates, you can append the data to the table. Access will reject any duplicates.

I must warn you, however, that your data contains commas within the data. Access, or Excel for that matter, will treat these as field markers and you will end up with the wrong number of fields. The car makes are separated by commas in some records and dashes in others.