duplicates in two fields...

[Stephen]

Hi Folks,

Relatively new at all this and I'm looking for a way to id duplicate in two
fiels. My table has 6 fields and I'm looking to find all duplicates on two
of the fields...

ie,

field 1 - 'color'
field 2 - 'size'

I'm looking for instances of 'red' & 'small' or 'green' & 'medium' if more
than one instance of both exist in a single record. The only problem is I'm
not sure what the potential duplicate values are because my fields deal with
book names and authors and the record count is around 38,000.

Please ask me to clarify if I'm not making it clear... I'm getting a litle
lost in my translation myself.

TIA!

 

[Jeff Boyce]

If I'm understanding correctly, you want to find "duplicates".

If you launch the query wizard, there's a "find duplicates" query it can
walk you through.

Regards

Jeff Boyce
Microsoft Office/Access MVP