Query - find a record that is in one table but NOT in another table

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I need a query to find a group of records that appear in one table, but do
NOT appear in another table.

I'm at a loss here, and can't even think what to look up in the Help
file......

Thanks for any suggestions to head me in the right direction here.
 
If you select New Query from the database window, there is a wizard that
will create a "Find Unmatched" query.

hth,
 
Oh my goodness, that was far too easy! And I wasted hours trying to figure
this out on my own.

THANK YOU!
 
Back
Top