Delete duplicates

[Guest]

I have appended duplicate records to several tables by accident. What is the
best way to delete the duplicate records?

 

[Guest]

Create a new table with the same structure as the previous table, add a key
or index with no duplicates, and append all the data from the old table to
the new table, that way the duplicates wont be appended.
Keep the new table structure to avoid duplicates in the future.

 

[Guest]

Hi,

Ofer, can you tell me how I can get rid of duplicate in my table. I have
many columns in my table and I only want to use part number and country as my
primary indicator of duplications in my table. So when I do run an append
query I want to get rid of duplicates for part number and country and all of
the row (description, expiration date, etc) in those duplication. I can
always run a duplicate query but there is just too many for me to do
manually. Do you know of any code I can use in the criteria field to
restrict it? Please look in the example below. As you can see the part
number and country is the same so I want to find any match that there are
duplicate for part # in the same country. But when I find the duplicate it
get deleted automatically when I run the append query including the
description, basically the whole row.

part #, description, expiration, status, country, class
111 apple 1/1/2006 yes USA B
111 orange 1/2/2006 no USA c