S
Shanin
I have a query that brings up employees who have yet to take a required
training. The query I have works fine except I need it to distinguish
between job codes and exclude certain people with certain job codes because
they do not need those trainings. I tried the following SQL but it seems to
only pull up the first individual.
SELECT T2.Training, [LastName]&", "&[FirstName] AS Name, T3.Title
FROM tblTrainingList AS T2, tblEmployees AS T1 INNER JOIN (Select Top 1
Title, EmployeeID from tblWage order by [DateofChange] DESC) AS T3 ON
T1.EmployeeID
WHERE (((T2.Training) Not in (SELECT DISTINCT Training FROM tblTraining
WHERE EmployeeID = T1.EmployeeID)))
AND T3.Title IN ("CN/ON", "Residential Supervisor", "Team Leader", "Q",
"Q/CaseCoordinator")
ORDER BY [LastName]&", "&[FirstName];
training. The query I have works fine except I need it to distinguish
between job codes and exclude certain people with certain job codes because
they do not need those trainings. I tried the following SQL but it seems to
only pull up the first individual.
SELECT T2.Training, [LastName]&", "&[FirstName] AS Name, T3.Title
FROM tblTrainingList AS T2, tblEmployees AS T1 INNER JOIN (Select Top 1
Title, EmployeeID from tblWage order by [DateofChange] DESC) AS T3 ON
T1.EmployeeID
WHERE (((T2.Training) Not in (SELECT DISTINCT Training FROM tblTraining
WHERE EmployeeID = T1.EmployeeID)))
AND T3.Title IN ("CN/ON", "Residential Supervisor", "Team Leader", "Q",
"Q/CaseCoordinator")
ORDER BY [LastName]&", "&[FirstName];