Deleting Duplicates

  • Thread starter Thread starter Bert Gale
  • Start date Start date
B

Bert Gale

There must be an easy way to delete duplicates - several
at once. If I have three fields and one table and they
are Email Address, First Name, and Last Name. If my name
and email address are in the table 6 times, how can easily
delete 5 of them and only keep one. I have this problem
with alot of records - any other suggestions would help.

Bert Gale
 
Bert,

I think the easiest way to clean up this table is to make a new one using a
MakeTable query selecting Distinct values:

SELECT DISTINCT [EmailAddress], [FirstName], [LastName] INTO [MyNewTable]
FROM [MyTable]

Once you have verified that MyNewTable is what you want, rename MyTable to
MyOldTable. Then rename MyNewTable to MyTable.


hth,
 
In Answer Wizard in Help enter "Automatically delete
duplicate records from a table" and follow the
instructions.
 
Back
Top