syntax error

[Guest]

I am trying to set the status of certain deliverables. I get an invalid
syntax error with this statment. I am sure I am missing parentheses somewhere
but I am not sure where.


=IIf([Date Rec'd]>[Dute Date],â€Past Dueâ€,IIf([Dute Date]<Date(),â€Past
Dueâ€,IIf([Date Rec'd]<[Dute Date],â€On Timeâ€,â€Pendingâ€)))


Thanks

 

[Guest]

You might get the error if the fields you comparing are not the same type.

 

[Larry Linson]

Looks to me as if you may be missing a left paren in front of each of the
last two IIFs.

Is that really supposed to read "Dute Date" or should it be "Due Date"?

Larry Linson
Microsoft Access MVP