Access: Need to compare for DIFFERENCES instead of similarities

  • Thread starter Thread starter eclehto
  • Start date Start date
What is the easiest way to find the inverse of matching fields?
Click to expand...

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

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.
 
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.
Click to expand...

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.
 
Back
Top