Query help

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have two tables. The first table holds a complete list of employees. The
second table holds a list of those employees that have been termed. I am
trying to create a query that will show all the employees that are not termed.
Please help.
 
Create a query with the two tables linked (for description, I am assuming
there is an employee id field common to both tables). Create an outer join by
double-clicking on the line connecting the tables. Select the option to show
all the fields from the table containing the complete list and only the
matching records from the other table. Place the records from the complete
employee table in the query and the employee id field from the other table.
In the criteria row, put "Is Null" under that field.
 
Back
Top