fujih
10-15-2004, 03:42 AM
I have a nested IIF statement such as:
IIf(blnWarning, IIf(strStage = 'Predicted' Or strStage = 'Requested', "State A", "State B"), "State C")
how can I convert that to a Case When statement inside a SQL statement?
I've tried
Case When blnWarning AND (strStage = 'Predicted' Or strStage = 'Requested') Then "State A"
Case When blnWarning AND NOT (strStage = 'Predicted' Or strStage = 'Requested') Then "State B"
Case When Not blnWarning Then "State C" End As myField
but I get an error message stating:
Incorrect syntax near the keyword 'And'.
IIf(blnWarning, IIf(strStage = 'Predicted' Or strStage = 'Requested', "State A", "State B"), "State C")
how can I convert that to a Case When statement inside a SQL statement?
I've tried
Case When blnWarning AND (strStage = 'Predicted' Or strStage = 'Requested') Then "State A"
Case When blnWarning AND NOT (strStage = 'Predicted' Or strStage = 'Requested') Then "State B"
Case When Not blnWarning Then "State C" End As myField
but I get an error message stating:
Incorrect syntax near the keyword 'And'.