Finding Duplicates

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

We are using access 2002. We have a table with all our customers in it, and
a table with prospect customers in it. There r a few duplicate records that
appear in both tables, but some have different phone numbers.

We need a way of getting access to search for the duplicate records using
surname, Tel 1, Tel 2 and Tel 3. And displaying the duplicate records side
by side in a form. Then we need a button the deletes the record from
prospect table and moves onto the next duplicate.

Does anyone know the best method for doing the above ?

Thanks

Ian
 
First use the query wizard to find duplicate records.

Then base a subform on the query.

Create a delete query that uses criteria that points to
the subform record's to pick up the id number of the
record you want deleted.

Instead of a command button to run the delete query, you
could set the subform's record event property to run the
query when double clicked. That not only ensures the
record is selected, which identifies the record to be
deleted for the delete query but it triggers the event
without having to move the mouse somewhere else.
 
Back
Top