Converting data stored numerically to Words in a report

[cmcdonald]

I have a table of customer orders whose order status is stored in a table as one of six or seven different numbers, each representing a different status. ie: 20 = Ready, 30=Pending, 40=Complete, etc.

I am unable to change the way they are stored in the table, but I would like to display the words they represent in a report rather than just the numbers. I can do this using the IIf function for just two options, but I am stumped on more than two.

Any ideas?

 

[Chopper]

Try using a nested iif:

iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, etc.))))

so, for your case it would be:
iif([Status] = 20, "Ready", iif([Status] = 30, "Pending", iif([Status] = 40, "Complete", "KeepGoing&quot))

hope this helps.

 

[cmcdonald]

Thanks! I feel silly for not working this out, but at least it's done now.

Cheers,
Cara