Unmatched Q problem

[Wulf13]

I'd like to create a query that shows me what employees haven't had a certain training (i.e. Bob hasn't had heavy machinery training). I've played with the unmatched records wizard and it just seems to not work out no matter how I connect them. I think the only two tables I need be concerned with are the 1st and 2nd table. Can anybody give me an idea on how to work this?

My tbls are as such:

1st Table:EMPLOYEEtbl
EmployeeID
EmployeeName

2nd Table:CompleteClasstbl
EmployeeID
classID
DateTaken

3rd Table:CLASStbl
className
classID

 

[Moniker]

SELECT * FROM CompleteClasstbl WHERE DateTaken Is NULL

If you want to link in the Employee's name and/or the Class Name, just link them with INNER JOINS, like this:

SELECT EMPLOYEEtbl.EmployeeName
    ,CLASStbl.className
    ,CompleteClasstbl.DateTaken
FROM 
    CLASStbl 
INNER JOIN (EMPLOYEEtbl 
INNER JOIN CompleteClassTbl ON 
EMPLOYEEtbl.EmployeeID = CompleteClassTbl.EmployeeID) 
ON CLASStbl.classID = CompleteClasstbl.classID;

I did that query in my head, so it may not be quite right, but you should get the idea of what I'm doing.