By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

Deleting Records with Similar Fields

P: n/a
Greetings All

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.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.