multiple field duplicate search

  • Thread starter Thread starter perryclisbee via AccessMonster.com
  • Start date Start date
P

perryclisbee via AccessMonster.com

I have a table that has 20 fields. I need to find all instances where there
are duplicate records, where ALL fields are identical. I there an easy way
of doing this? This table has approx 100,000 records. I have tried it where
the count on a specific field is >1, but that doesn't seem to work when
applied to all 20 fields simultaneously. Any ideas?

Thanks,

Perry
 
Perry

Are you saying that you could have a record in which Field1 = Field2 =
Field3 = ... Field20? Or more than one record where the values match for
each/every field?

Have you looked at the duplicates query wizard?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I'm looking for more than one record where the values match for each and
every field. Exact matches across the board. The duplicate query wizard
will calculate up to 10 fields. I just want to do that for all 20.

Jeff said:
Perry

Are you saying that you could have a record in which Field1 = Field2 =
Field3 = ... Field20? Or more than one record where the values match for
each/every field?

Have you looked at the duplicates query wizard?

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have a table that has 20 fields. I need to find all instances where
there
Click to expand...
[quoted text clipped - 8 lines]
Perry
Click to expand...
Click to expand...
 
You can take the query created by the duplicates query wizard and dig into
design view to see how it is done. Then you'd just need to extend how it's
done to more of the fields.

Or, if you have the patience, you could sort the table by all those fields,
and the duplicates would bunch up.

On the other hand, if what you REALLY want to accomplish is to end up with a
single copy of each unique record (i.e., NO duplicates), then that's a
simple matter.

Regards

Jeff Boyce
Microsoft Office/Access MVP


perryclisbee via AccessMonster.com said:
I'm looking for more than one record where the values match for each and
every field. Exact matches across the board. The duplicate query wizard
will calculate up to 10 fields. I just want to do that for all 20.

Jeff said:
Perry

Are you saying that you could have a record in which Field1 = Field2 =
Field3 = ... Field20? Or more than one record where the values match for
each/every field?

Have you looked at the duplicates query wizard?

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have a table that has 20 fields. I need to find all instances where
there
Click to expand...
[quoted text clipped - 8 lines]
Perry
Click to expand...
Click to expand...
Click to expand...
 
Back
Top