how to delete dupe entries

  • Thread starter Robert Blackwell
  • Start date
R

Robert Blackwell

I receive contact information from a response card, and it's all in an
access dbase now. I just realized that there are a good number of duplicate
entries. I need to delete the extra/duplicate entries if the address fields
match.

The records all have their own fields for name, address, city, state and zip
etc etc.

So, I need to compare the address fields and if there is more then one with
the same info I want to delete the extra entry.

Thanks
 
T

Tom Wickerath

Access provides a Find Duplicates query wizard, which will help walk you through the steps of
creating a SELECT query to display the duplicates. I recommend looking at the results of the
SELECT query, and deleting the appropriate record(s) yourself, rather than trying to automate
this process. If you have related child records, you should first update the foreign key(s) to
the value of the primary key for the record that you wish to retain. You'll need to do this if
you have referential integrity established. I'd make sure that you do not have cascade delete
enabled, or else you may inadvertently delete related records.

To get started, select the Queries object in the database window. Then click on the New button
and select the fourth choice in the list: Find Duplicates query wizard.

Tom
______________________________

"Robert Blackwell" <robbieOMGwowcentralDOTcom> wrote in message

I receive contact information from a response card, and it's all in an
access dbase now. I just realized that there are a good number of duplicate
entries. I need to delete the extra/duplicate entries if the address fields
match.

The records all have their own fields for name, address, city, state and zip
etc etc.

So, I need to compare the address fields and if there is more then one with
the same info I want to delete the extra entry.

Thanks
 
R

Robert Blackwell

Thanks, I'll check it out. I'm only dealing with one table and no references
or anything so I wont have to worry about that other stuff.
 
Top