C
Chris Nebinger
If there are duplicates in the tblWage, which title do you
use? Is there a date field or something that you can sort
on? This will work for you...
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 [YOUR
DATE FIELD] DESC) AS T3 ON T1.EmployeeID =T3.EmployeeID
WHERE (((T2.Training) Not In (SELECT DISTINCT Training FROM
tblTraining WHERE EmployeeID = T1.EmployeeID)))
AND T3.Title IN ("CN/ON", "Residnetial Supervisor", "Q")
ORDER BY [LastName]&", "&[FirstName];
Chris Nebinger
use? Is there a date field or something that you can sort
on? This will work for you...
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 [YOUR
DATE FIELD] DESC) AS T3 ON T1.EmployeeID =T3.EmployeeID
WHERE (((T2.Training) Not In (SELECT DISTINCT Training FROM
tblTraining WHERE EmployeeID = T1.EmployeeID)))
AND T3.Title IN ("CN/ON", "Residnetial Supervisor", "Q")
ORDER BY [LastName]&", "&[FirstName];
Chris Nebinger