One Expression in a Query IF/ ELSE?

[gwendon]

I am using ACCESS 2000 and I have a simple table with the following fields: HCHV_PROGRAM/DateIn/DateOut/TimeInProgram. Within a Query I can create a DateDiff function that will give me TimeInProgram based on DateIn minus DateOut Or DateIn minus the Current Date. But what I need is a TimeInProgram based on DateIn minus DateOut if one exists otherwise I need a TimeInProgram based on DateIn minus the Current Date. A sort of IF/ELSE in one expression, in a query, if that is possible?

 

[jebry]

Hi!

Yes it is possible:

IIf(IsNull([DateOut]) = True, DateDiff("dd", [DateIn], Date()), DateDiff("dd", [DateIn], [DateOut])) As TimeInProgram

hth
Jeff Bridgham
bridgham@purdue.edu

 

[gwendon]

Thank you very much Jeff it works great!!!
The only thing I had to change were the "dd" to "y"