I have a query where the first column is an integer type number 0-100 representing a percentage. I have learned how to create a second field that converts this integer into letter representation (see below):
QualPercent:IIf([PercentComplete]=100,"Q","NQ")
This works fine. However, this is only for two cases. Any idea how to do the same sort of thing for three or more variables? I tried using If and ElseIf statements in query box, but couldn't make it work.
I'd like to set 100 = Q
99 = I
0-98 = UI
null = NQ
I'm thinking I can keep combining IIf statements and replace the "NQ" in the first statement above with a second IIf statement and so on and so on...
Thanks,
Brian
QualPercent:IIf([PercentComplete]=100,"Q","NQ")
This works fine. However, this is only for two cases. Any idea how to do the same sort of thing for three or more variables? I tried using If and ElseIf statements in query box, but couldn't make it work.
I'd like to set 100 = Q
99 = I
0-98 = UI
null = NQ
I'm thinking I can keep combining IIf statements and replace the "NQ" in the first statement above with a second IIf statement and so on and so on...
Thanks,
Brian