Not sure of the official name

[Meaghan]

I need to write a query that will give me all the records in table A that
aren't in Table B I know there is a way to do this, but i can't seem to
figure it out.

Help!

 

[John W. Vinson]

I need to write a query that will give me all the records in table A that
aren't in Table B I know there is a way to do this, but i can't seem to
figure it out.

Help!

The "Unmatched Query Wizard" will build this query for you.

John W. Vinson [MVP]