That worked great. Thank you.
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: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Wednesday, September 14, 2011 12:40 PM
Subject: RE: [MS_AccessPros] Date Logic in a Query.
Art,I would start by adding a column [MthsBetween] to tlkpTrainingCode. Enter 36 for First Aid and 24 for AED. Then in your text box, enter something like:=IIf(IsNull(TrainingDate),"Initial Training Not Taken",Format(DateAdd("m",MthsBetween,TrainingDate),"mm dd yyyy") )IMO, hard-coding values is not the correct solution. Data belongs in tables, not in code or expressions.Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Wed, 14 Sep 2011 17:20:58 +0000Subject: [MS_AccessPros] Date Logic in a Query. I have the following query:SELECT qryEmployeesExtended.[Employee Name], tblEmployeeTraining.TrainingDate, tlkpTrainingCode.TrainingCodeNameFROM qryEmployeesExtended INNER JOIN ((tblEmployeeTraining INNER JOIN tblTrainingGroup ON tblEmployeeTraining.TrainingGroupID = tblTrainingGroup.TrainingGroupID) INNER JOIN tlkpTrainingCode ON tblTrainingGroup.TrainingCodeID = tlkpTrainingCode.TrainingCodeID) ON
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar