Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.
Hi there
I've got an access database where it holds customer details. However this db is rather old and so has many duplicated contact information stored inside.
The db has several fields but the 3 fileds of most importance are:
PostCode, Surname, Add1
The db looks something like this
EX4 3LD, Jones, 100 West Hill
EX4 3LD, Jones, No 100
EX4 3LD, Jones, Number 100 West Hill
EX4 3LD, Jones, 100 WestHill
I've got over 2000 of such records and I'm trying to figure out how to delete duplicate entries so that only 1 occurence of each contact exists in the db. However, there is a small issue with regards to the format of the records stored in the db. Whilst record 1 seems to be the correct one, record 4 seems to be equally correct (assuming we don't have an A-Z handy). The problem I've got is that I need a way to get rid of the obvious errors (in this case records 2 & 3) and after, delete a randomly chosen record so that there's only 1 occurence of the record in the db.
Is there a way of doing this so that I only have 1 record for each customer?
Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.
Posted on 2003-10-15 at 02:42:49ID: 35574349
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.