syntax error

M

MMH

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
 
L

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
 
Top