if/then statement limits

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

Guest

is there a limit to the number of iif statements i can have in one field?
 
255 characters??? If nothing else, I would think that one, but you never
know till you try. =)

Sharkbyte
 
If you need so many iif statements, you may consider use some other function
like choose or switch.

What are you trying to do ?

Mauricio Silva
 
I generally find that more than a couple IIf()s suggests using a lookup
table of ranges or related information. You can maintain data much easier
than complex IIf()s.

However you have provided very little information regarding your situation.
 
You must log in or register to reply here.

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

Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
IIF statement in text box 3
Query Criteria IIf statement 4
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
using a IIF statement with a Like statement 7
Too many IIF statements 3
Multiple iif challenge 2
SQL IIF statement with TOP 10 0

Back
Top