Query Records Out

[Lamar]

I have Table A and Table B. Both contain client's last
name(some are the same and some are different). I want to
run a query where I can query out the names that are in
Table B but not Table A. These tables have thousands of
entries.

I trying to compare Table B and Table A. I have tried the
Not operator but it does not work.

 

[anonymous]

Try an unmatched query, it's a wizard that may help.