Finding entries with two matching fields

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a worldwide membership database where I need to check that
members do not have duplicate entries.

I propose to check the combination of "LastName" and "ClubName". So
the query needs to say:

"Which records have the same "LastName" combined with "ClubName"?

Thanks,

Robin Chapple
 
With the method you propose, what do you do about John Smith, Jane Smith,
Ron Smith, Rhonda Smith, Frank Smith, and Frankie Smith who all belong to
the same club?

Pick the fields that should, all together, determine uniqueness, use them as
GroupBy fields in a Totals Query with a Count. Use a criteria of <> 1 on the
Count field, and you'll have a display of the ones with duplicate records.

Once you clean those up, create an index of all the fields that determine
uniqueness, and specify no duplicates. If the data entry is accurate, that
will prevent duplicates in the future.

Just do not expect that to find every duplicate... the same person could be
in the database twice as John Smith and Jonathan Smith, which would not be
an exact duplicate.

Larry Linson
Microsoft Access MVP
 
Back
Top