In an expression, I am getting a syntax error message when I try to run the query with nested IFF statements involving numbers in different ranges. Would anyone please help me with the correct syntax. Thanks very much.
=IIF([TableA]>-1,"On or Ahead of Target", IIF([TableA] is between -1<and>-9,"Behind 1-9 Days", IIF([TableA] is between -10<and>-14,"Behind Two Weeks", "Over Three Weeks Behind")))
=IIF([TableA]>-1,"On or Ahead of Target", IIF([TableA] is between -1<and>-9,"Behind 1-9 Days", IIF([TableA] is between -10<and>-14,"Behind Two Weeks", "Over Three Weeks Behind")))
Nested IIF statements in a query expression
0 commentaires:
Enregistrer un commentaire