Deleting Duplicates

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
 
C

Cheryl Fischer

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,
 
G

GRayL

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