Creating a query that compares tables 1

[smileychickie]

I have a table that logs hours worked on a particular job (hours table) and a table that holds all of the job data (jobs table). How do I create a query that will show me all of the jobs that are in the hours table but NOT in the jobs table? I want to be able to show which jobs have hours logged to them that aren't in the main jobs table.

 

[Rohdem]

Access has a wizard call 'Find Unmatched Query Wizard' that will do just what you want to do. It will even walk you through it step-by-step. Just go to the query window, click new, then select the 'Find Unmatched Query Wizard'. Mike Rohde
rohdem@marshallengines.com

 

[smileychickie]

Thank you Rohdem for your help. That is exactly what I needed!