Comparing tables

[Guest]

I would like to compare two similar tables and have my query return values
that occur in one but do not occur in the other. Does anyone know how to do
this?

 

[Arvin Meyer [MVP]]

Actually, there is a query wizard to do just that. When you start a new
query, just pick:

Find Unmatched Query Wizard

 

[Pat Hartman \(MVP\)]

Use the unmatched query wizard.