Two tables

[Galsaba]

Table #1 has 200 rows. Table #2 has the same fields, but 50 rows.
I want to make a make table query that will produce a third list that will
contain
all those rows which are in table #1 but not in table #2.
(So table #3 will have 150 rows.)

Thanks,
Aaron

 

[Douglas J. Steele]

Try using the Find Unmatched Query Wizard.