Help with IIf statement
I'm trying to use the following IIf statement, but I'm getting "The expression you entered contains invalid syntax." I am very new to using Access, so any help would be appreciated.
Progress:
IIf( ([Math Raw]> 0 And [Math Raw] < 12), "Did not meet",
IIf( ([Math Raw]>=50 And [Math Raw]<=52),"Exceeded",
IIf( ([Prior Math Scale] >= 1710 And [Gain Score] >= 135), âExceededâ,
IIf( ([Prior Math Scale] >= 1710 And [Gain Score] >= 52), âMet Progressâ,
IIf( ([Prior Math Scale] >= 1710 And [Gain Score] < 52 And [Current Math Scale] > 1762), âMetâ,
IIf( ([Prior Math Scale]< 1710 And [Gain Score] >=135), "Exceeded",
IIf( ([Prior Math Scale] < 1710 And [Gain Score] >= 31), "Met", "Did Not Meet")))))))
Is there a problem with the expression that has 2 "And"s?
|