Not matching query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a query from 2 tables that show the matching data in 4 fields
from both tables. I want to make a query that shows the NOT-matching data
from both tables.

How exactly would I do that?

One more question, what does putting "is null" in criteria of query design
view do?
 
Jinny

The Query Wizard can help you create an "unmatched" query. Be aware that
there's more than one "flavor"!

Are you looking for all the values in Table1 that are not matched in Table2,
or all the values in Table2 that are not matched in Table1 (these are NOT
equivalent).

Or are you looking for "anything in any table that isn't matched in the
other table?"

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top