Display value based on record field

[WCDoan]

I have a field in a record that can have 3 possible values, "D","C", or "O".
I have a report on which I need to print out what these codes mean D=Dog,
C=Cat, and O=Other. I know how to do this with an IIf when there's only 2
possibilities, but don't know how to do it for 3. Can you use nested Ifs as
the control source like you can with just a simple If? If so how?
Thanks
RandyM

 

[John Spencer]

IIF(Field="D","Dog",IIF(Field="C","Cat",IIF(Field="O","Other",Null)))