Calculation problem

[cometdragon]

Hi, I'm a newbie who really needs help on a work project. Please excuse my ignorance. My project is to create a database for a lab for training dates of employees on various laboratory benches with dates of completed competency testing performed six months later. The supervisors want to be able to query when an employee's six month competency testing is due. A query has been created with the existing training dates and completed six month competency test dates. I was able to use the DateAdd function to add 180 days to the training date but how to I create a calculation that works only for training dates with no existing competency dates? When I tried using the IIF function and IsNull or IsEmpty the query returned '0'. Your help is greatly appreciated.

Elizabeth

[Rawb]

What does the table look like? Are you leaving the the exam dates blank or are you filling them with some dummy value?

If you're leaving them blank, then you should have been able to just check for IsNull([ExamDate]).

Can you post the SQL Statement you're using? That might give us some more information on what's going on.

[cometdragon]

Thank you for responding for more information. I found someone at work, in another department, who helped me solve the calculation.