Find Non-matching fields

K

Kathy

I have a small table with one field with names, and two other fields (this
comes from a spreadsheet) containing info that SHOULD match. If the two
fields do not match, we need to know. It's not an unmatched query, but rather
filtering out those records where the two fields do match, as I do not need
to be concerned with these.

Any ideas on how to accomplish this?
 
J

Jeff Boyce

Kathy

Are you saying that you want to see rows in the table where Field1 = Field2?

Or perhaps all the rows OTHER than where Field1 = Field2?

I might be missing something, but that sounds like creating a query, adding
the table, adding the ID field and Field1, then, in the Selection Criterion
"cell" under Field1, putting something like:
<>[Field2]

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top