ACCESS FEED: Re: [MS_AccessPros] Date Logic in a Query.

Rabu, 14 September 2011

Re: [MS_AccessPros] Date Logic in a Query.

I am not sure if this made it the first time. My Yahoo is doing some wierd stuff.

With warm regards,

Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947

1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training

From: Art <dbalorenzini@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, September 14, 2011 12:20 PM
Subject: [MS_AccessPros] Date Logic in a Query.

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

[Non-text portions of this message have been removed]