Simple join problem

[unnamedplayer]

Hi all,

I need some help. Let's say I have a table that contains employees and another that contains trainings they should have completed.

The trainings table has columns: TrainingID, EmpID, Title, DateCompleted

I need to find all employees who have not completed a specific training. For example, if there is a training titled "Ethics" I would want to be able to find all those employees who have not yet completed the training.

I feel like I should be able to accomplish something like this using a join but nothing I have tried has worked. Any ideas?

Thanks!

 

[Scooterbug]

Create a query where you list all the Employees who have completed the desired training. Save it. Create another query using the previous query and the employee table. Join on the EmployeeID. Set the join to include all records from the Employee Table and only those who match from the training table. If you run it, the field for the desired training will be null for employees who haven't done that training.

 

[HiTechCoach]

What you need may be an Unmatched query.

There is a query wizard that will help you create this.