Hi All!

I am trying to to use a IIF statement in an expression in my Query that will return both Numbers and Text.

I think I may have the format wrong, so any help will be appreciated.

I have nested IIF statements that evaluate a person's score, and if they get a certain score then I want it to return a dollar amount (which I have made it do), but then if they get a very low score I want it to return a text string "See Your Manager".

Below is an example:

Field: Final_Pay: IIF([Final_Score]=100,19,IIF([Final_Score]>50,18,"See Your Manager"))
Total: Expression

I had the format set to currency, and it will return the number values as $19.00 and $18.00, but for the "See Your Manager" it returns #Error.

I tried changing the format to "Standard" and got the same results, and then I tried "Fixed" and still the same results.

Any help will be appreciated to setting the format so it will return both numbers and text.

Thanks in advance!


Note: I am a beginner with Access, so I hope this isn't a silly question.