The easiest problem you'll probably have to deal with!

[OliverWilton]

I feel kind of stupid asking this, but i just don't know! I have radio buttons on a form with the attributes of Active, Inactive or Proto-type. If you click it on the form then in the table it assigns a numeric value, but on the report i want it to display the text.

I have it working for 2, so if it =1 then it displays Active, else it displays Inactive. Like so:

=IIf([Active/Inactive/Prototype]=1,"Active","Inactive")

How would i write it so that i could display all 3?

Thank you!

 

[pbaldy]

If they may change (and even if not), I'd be inclined to create a table that you can join on to get the values. The direct answer to your question is that you would embed a second IIf() function within the False argument of that one to deal with 2 and 3.

 

[gemma-the-husky]

you could look at switch function in your query