Greetings All
I have requested help before and I really need your help in this. I
am working on an Access database of contacts. I have plenty of
records but plenty of them are almost duplicates. Data in some fields
are misspelled and entered as completly different records. I wonder
how could I clean the database in a way I have single record of
contact information for each contact.
Example:
Record 1
Name:Johns Smith
Tel: 734-123-4567
Address: 123 Any Street
Title: VP of Operations
Company: ACME
Record2
Name: John Smith
Tel: 734-123-4567
Address: 123 Any Street
Title: VP of Operations
Company: ACME
So, record 1 and 2 are basically identical; the name is misspelled.
If someone entered new records because names were misspelled, how can
I go and clean the data of such records.
Best Regards
A.D.B.