IIf Statement String Expression

G

Guest

If any one can help me on this one, that would be great.
I am running a query off an IIf statement. It is stringed through 14
different field names and it has been working great. I have been trying to
add 3 more field names and it keeps giving me a "The expression you entered
is too complex"
Any way to correct this or make it work.
Here is part of my expression.

=IIf([LineType]="OFC (reg)",[OFC (reg)],IIf([LineType]="Cyber II",[Cyber
II],IIf... etc. etc.

Thanks!
Luman
 
G

Guest

There is a limit of how many nested iif statements you can have, but I do not
remeber the exact number. It would also help to post the entire statement.
Also, from what little you posted, there may be a better database design than
what you are using. It seems strange to have to need 17 nested Iif
statements to perform a query, but there is not enough information on your
database to make any suggestions.
 

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 My Expression Contains Wrong number of arguments 0
Please Help! The Expression you entered is too complex 0
Help with iif statement in query 3
Iif Statement help 6
Limits of IIF? 1
Data Mismatch in Excel 2010 4
Option Buttons to Pass Criteria to Query 6
IIF Statement 3

Top