S
Shanin
Currently I have the following query:
SELECT T2.Training, [LastName] & "," & [FirstName] AS Name, T1.DateHired
FROM tblEmployees AS T1, tblTrainingList AS T2
WHERE (((T2.Training) Not In (SELECT DISTINCT Training FROM tblTraining
WHERE EmployeeID = T1.EmployeeID)) AND ((T1.Separated)=No))
ORDER BY [LastName] & "," & [FirstName]
WITH OWNERACCESS OPTION;
I have gotten suggestions before, but when I tried them, I had no luck of
getting the proper results. This query basically shows me who has not taken
a training that is in the training list. What I would like it to do is sort
out those who do not need the trainings, which can be determined by job
title. Job title information is in the the table tblWage, which also tracks
wage history, job history, etc.
The table consists of the following:
EmployeeID-PK
DateofChange-PK
Title
DayWage
NightWage
Status
I would like my query to list who has not taken a training and look at the
last Title and choose only those whose latest entry in the tblWage.Title
(which would be consistant with the latest DateofChange) = "CN/ON",
"Residential Supervisor", "Q", "Q/Coordinator".
Setting that up as T3 and using some earlier suggestions gave me mixed
results where it would only pull up one person*shrugs* Any help would be
appreciated.
The basis of this whole query is that employees have 60 days to complete
these training upon being hired. If they are done in that time frame, they
lose a portion of their yearly increase, which is why I have the HireDate
field in the query so I can look at the end of the year.
SELECT T2.Training, [LastName] & "," & [FirstName] AS Name, T1.DateHired
FROM tblEmployees AS T1, tblTrainingList AS T2
WHERE (((T2.Training) Not In (SELECT DISTINCT Training FROM tblTraining
WHERE EmployeeID = T1.EmployeeID)) AND ((T1.Separated)=No))
ORDER BY [LastName] & "," & [FirstName]
WITH OWNERACCESS OPTION;
I have gotten suggestions before, but when I tried them, I had no luck of
getting the proper results. This query basically shows me who has not taken
a training that is in the training list. What I would like it to do is sort
out those who do not need the trainings, which can be determined by job
title. Job title information is in the the table tblWage, which also tracks
wage history, job history, etc.
The table consists of the following:
EmployeeID-PK
DateofChange-PK
Title
DayWage
NightWage
Status
I would like my query to list who has not taken a training and look at the
last Title and choose only those whose latest entry in the tblWage.Title
(which would be consistant with the latest DateofChange) = "CN/ON",
"Residential Supervisor", "Q", "Q/Coordinator".
Setting that up as T3 and using some earlier suggestions gave me mixed
results where it would only pull up one person*shrugs* Any help would be
appreciated.
The basis of this whole query is that employees have 60 days to complete
these training upon being hired. If they are done in that time frame, they
lose a portion of their yearly increase, which is why I have the HireDate
field in the query so I can look at the end of the year.