Comparing 2 list

[Guest]

I want to compare 2 tables. Table one has tape numbers that were ejected.
Table 2 has the tape numbers that were suppose to be ejected. I want to
compare the 2 tables and show the tapes that were not ejected or any other
discrepancies.

 

[Rick B]

Build an unmatched query. The wizard will walk you through it.