IsNull and IIf together

[Guest]

I can't figure out what is wrong with this statement.

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date]),"Past Due","On Time")

My error says i have the wrong number of expressions - but I don't see it.

Thanks for the help!!!

 

[Douglas J Steele]

It's your parentheses. You've got it in the wrong place in the 2nd IIf
statement:

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date],"Past Due","On Time"))

 

[Dirk Goldgar]

I can't figure out what is wrong with this statement.

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date]),"Past Due","On Time")

My error says i have the wrong number of expressions - but I don't
see it.

Thanks for the help!!!

I think you have a misplaced closing parenthesis on the nested IIf
function. Try this:

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date],"Past Due","On Time"))

Note that the above will have been wrapped by the newsreader, but was
entered on one line.

 

[Guest]

THANKS!!!!! It has been driving me NUTS!!!!

I can't figure out what is wrong with this statement.

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date]),"Past Due","On Time")

My error says i have the wrong number of expressions - but I don't
see it.

Thanks for the help!!!

I think you have a misplaced closing parenthesis on the nested IIf
function. Try this:

=IIf(IsNull([Date Completed]),"Pending", IIf([Date Completed]>[Due
Date],"Past Due","On Time"))

Note that the above will have been wrapped by the newsreader, but was
entered on one line.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)