I want my query to show unmatch results of two tables. For example in one
table I have certain rows of data that are not in another table. I want to
show those rows that are not in the other table in my query.
When you create a new query, one of the options is called
Unmatched Query wizard

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I want my query to show unmatch results of two tables. For example in one
> table I have certain rows of data that are not in another table. I want
> to
> show those rows that are not in the other table in my query.