Access: Need to compare for DIFFERENCES instead of similarities

[eclehto]

What is the easiest way to find the inverse of matching fields?

 

[golfinray]

There is an Unmatched query in your query types.

 

[John W. Vinson]

What is the easiest way to find the inverse of matching fields?

Please explain what you mean by "differences" and "inverse". Perhaps an
example of your data would help. As posted the question is really ambiguous...

 

[eclehto]

Please explain what you mean by "differences" and "inverse". Perhaps an
example of your data would help. As posted the question is really ambiguous...

If you drag a field from one table to another in a query, you get the
matches. I want to find the records that do not match instead.
Thanks.

 

[John W. Vinson]

If you drag a field from one table to another in a query, you get the
matches. I want to find the records that do not match instead.
Thanks.

So if you have 100 records in TableA, and 200 records in TableB, and none of
them match, you want to see all 20,000 mismatches? The first record in TableA
is not equal to any record in TableB, so you will see all 200 as "records that
do not match".

Reading behind your literal words, if you want to see that subset of the
records in TableA which have no matching record in TableB, then Golfinray's
suggestion is exactly correct: create a new Query, and use the "Unmatched
Query Wizard" to create it.