M
Mary
I'd like to create an If Elseif statement to display the Status with three
possible values. My query has a field for CancelDate and a field for
CompleteDate. I'd like to show the Status as Open, Complete or Cancel based
on these two fields.
I think it should look something like this, but obviously need help. I've
always used IIF, not Elseif.
If [Tasks]![TaskCompleteDate]>0 Then Complete
Elseif [Tasks]![TaskCancelDate]>0 Then Cancel
Else Open
Thanks for your help.
Mary
possible values. My query has a field for CancelDate and a field for
CompleteDate. I'd like to show the Status as Open, Complete or Cancel based
on these two fields.
I think it should look something like this, but obviously need help. I've
always used IIF, not Elseif.
If [Tasks]![TaskCompleteDate]>0 Then Complete
Elseif [Tasks]![TaskCancelDate]>0 Then Cancel
Else Open
Thanks for your help.
Mary