Software

Ask something
Question Locked

if then statement code

0 helpful
4 replies

by dgearheart

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to write a statemtn in access that will determine if a date is null and if it is respond with "0", if it is true, I want to be able to count the days (datediff) between it and a second date. If the second date is null, I would like to count the days from the first date to "today". I also have a re-start and re-end date that I would like to incorporate and count all days. I would love any feed back and direction possible.

4 replies

by john.a.wills

if isnull (me.date1) _
then
me.X = 0
else
if isnull (me.date2) _
then
me.X = datediff(me.date1,today, whatever)
else
me.X = datediff(me.date1,me.date2,..)
endif
endif

by dgearheart

John.a.wills,

Thank you for your help, however when I type in the following I get an error that states, "The expression you entered contains invalid syntax. You may have entered an operand without an operator." I think my problem is that I do not have the proper punctuation.

Rest days: if is null [Rest Duty Start Date]_ then Rest days=0 else if isnull [Rest Duty End Date] then Rest days= datediff([Rest Duty Start Date],today) else [Rest Duty Start Date],[Rest Duty End Date] end if

Please help, I am not sure the proper code with proper punctuation.

Thanks

by john.a.wills

is available on datediff - I cannot help there off-hand. More important, perhaps: you have "Rest days" as two separate words outside brackets.

This discussion is closed to new replies.