Finding duplicates

[Guest]

Hi guys

Im using Access 2003 and I have an Access 2000 database and I have a
challenge of finding and extracting duplicated records. Some records are
exactly identical,some are partially identical .

The partially identical would have to have the same address to be labelled
duplicates e.g.DION BAUMANN and DION BAUNMANN orAdolf HEUERMANN and Adolf
HOUERMANN have the addrresses but the names are a bit different, which could
have been a typing error.

Another challenge is extracting records where the address is the same and
the name is the same but part of the name is Abbreviated e.g.
BYK MADAUS (PROPRIETARY) LIMITED
BYK MADAUS (PTY) LTD.

The other is is extracting records where the name is the same and the one
address is a postal address and the other is a physical address e.g.
Andre ENGELS Kigelia Str 53 Flora Park PIETERSBURG 0700
Andre ENGELS P O Box 5852 PIETERSBURG NORTH 0700

This is a database is used for people who can register something more than
once,but instead of using the same name and addrress as before,they enter it
again and thats where the duplication originates.

Could someone give me some help? if possible in code.

 

[[MVP] S.Clark]

There's no magic bullet, as you've discovered. Trial and error. Zip, City,
Last name is a good place to start. After that, it's a case by case basis.