IIf statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement 9
Rich Text Format 0
Report to bring back active field only 4
Access Building a IIF expression in Access 0
How do I create a complex report? 1
problem with IIf Statement 7
Problems with AND in multiple IIF statements 5
IIF statement question 3

Back
Top