syntax error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top