IIf statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryis - 12 Jan 2007 22:08 GMT

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

Reply to this Message

Duane Hookom - 13 Jan 2007 05:09 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> 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
[quoted text clipped - 5 lines]
> Thanks in advance
> Ryan

Reply to this Message