IIf statement

[Ryis]

I am trying to have a field display different data depending on what one
field says. the one field will contain 20 different options and based on
which one is chosen i would like another field to display something different
based on each option in the first field.

If this makes sense to anybody please help!!

Thanks in advance
Ryan

 

[Duane Hookom]

20 different options is about 18 more than should be used with IIf(). I
expect you should be storing some values in tables to look up the value to
display.