Compare querys

M

Markus

Hallo

I hope some on can help I am trying to compare two tables and I need a query
that only shows me the things that are missing from the one table that's not
in the other if you look at my example below Table 1 has all the data and
table2 has a missing 1 and 2 so I need a query that shows me that 1 and 2 is
missing from table2 how is this possible.

Table1 Table2
1 3
2 4
3 5
4
5

Many Thanks

Markus
 
J

Jeff Boyce

Markus

Access' Query Wizard has an "Unmatched..." template. This walks you through
finding values in Table1 that are not in Table2.
 
Top