I have the following query:
SELECT qryEmployeesExtended.[Employee Name], tblEmployeeTraining.TrainingDate, tlkpTrainingCode.TrainingCodeName
FROM qryEmployeesExtended INNER JOIN ((tblEmployeeTraining INNER JOIN tblTrainingGroup ON tblEmployeeTraining.TrainingGroupID = tblTrainingGroup.TrainingGroupID) INNER JOIN tlkpTrainingCode ON tblTrainingGroup.TrainingCodeID = tlkpTrainingCode.TrainingCodeID) ON qryEmployeesExtended.EmployeeID = tblEmployeeTraining.EmployeeID
WHERE (((tlkpTrainingCode.TrainingCodeID) In (17,30)));
This returns all employees that have a training code of 17 (First Aid) or 30 (AED).
What I need to is add a unbound textbox to a report and calulate the if the Training Date is blank then have a message such as Initial Training Not Taken, or if there is a training date then I need to calculate the date if the Training code is (17)First Aid have the date dropped in that is 3 years after the TrainingDate or if the Training Code is 30 (AED) have the date calculated that is 2 years later than the training date.
Any ideas?
Thank you
Art Lorenzini
Sioux Falls, Sd
Tidak ada komentar:
Posting Komentar