Items in one table not in another

[bmain]

I have two tables. Some items in the tables match and I want a query that
pulls the items in the larger table that are not in the smaller table.

 

[Ofer Cohen]

Use the query wizard to create an UnMatch records query that will list the
records that exist in one table but not in the other.

 

[Rick B]

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

 

[bmain]

I found the unmatched query under the menu. Thanks for your help.

 

[bmain]

I found the unmatched query under the menu. Thanks for your help.