I am working on a scheduling program and I have several tables of data for a daily schedule I have written union queries and append queries to gather all the data at run time and put it into another table. What I would like to do is compare the employees from the table that is created at run time to the employees in the employees table, then I want it to give me all the employees that don't have a match that way I can see who is available. Does any one know how to make a comparison query? or is there another way to do this?

Thanks in advance

Bill