Question

Asked on 2003-10-15 at 02:25:57ID: 27000668

Need to delete duplicates

by: brimful500

Rating8.4Very Good

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?

Related Solutions

Solution

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.

About this Solution

View This Solution - Start Your 30 Day Free Trial
Zone
general
Tags
Participating Experts
4
Solution Grade
A

Replies

 by:

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.

 by: sigs66

Posted on 2003-10-15 at 02:46:15ID: 35574350

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.

 by: DoppyNL

Posted on 2003-10-15 at 03:14:54ID: 35574351

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.

 by: nico5038

Posted on 2003-10-15 at 03:16:07ID: 35574352

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.

 by: MrRobin

Posted on 2003-10-15 at 03:20:08ID: 35574353

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.

 by: MrRobin

Posted on 2003-10-15 at 03:21:54ID: 35574354

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.

 by: brimful

Posted on 2003-10-15 at 03:58:01ID: 35574355

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.

 by: nico5038

Posted on 2003-10-15 at 10:09:10ID: 35574356

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.

Log In

Forgot your password?Sign up

Top Experts

  1. jimpen

    8,346

    0 points yesterday

    Profile
  2. als

    2,110

    0 points yesterday

    Profile
  3. boag2000

    2,000

    0 points yesterday

    Profile

BrowseAre you an Expert?