Query to compare two tables

[David]

Hi Everyone!

I'm trying to make a query that will compare a field in two different
tables. Both of the fields are called drivers. I want the output to
display any driver that is not listed in the other table.

Basically one table has all the drivers that worked for one day, and the
other table has all the drivers in the company. I want the output to
display any driver that didn't work for that day.

After I get this data I would like to display it at the end of an existing
report that shows all the work that the drivers who worked did.

Any ideas?

Thanks!

Dave

 

[Guest]

Hi David
In Access there is a wizard for unmatch query use that feature to build this
query that you want to do. It is easy and self explaionatory.

 

[David]

That did it! Thanks! Any idea on how to throw this data on the end of an
existing report?