"The expression you entered is too complex"

[Ed J]

In designing a query I have built an expression that
contained a nested if statement. When I added one more
level I suddenly get the message "The expression you
entered is too complex". What is this telling me? Is
there an error in the last expression? Or is there a
limit in the number of if statements? When I remove the
last statement it works well. Any ideas?

 

[fredg]

In designing a query I have built an expression that
contained a nested if statement. When I added one more
level I suddenly get the message "The expression you
entered is too complex". What is this telling me? Is
there an error in the last expression? Or is there a
limit in the number of if statements? When I remove the
last statement it works well. Any ideas?

I assume you mean IIF, as you cannot use If in a query statement.

I believe there is a limit to the number of nested IIF's you can use,
but I can't recall what that number is.

One way to find out what the difficulty is:
Add that finall IIf, then remove the one preceding it, so that now you
have the same number of IIf's. Do you get that same error now. If so,
then it's not the number of IIf's but an error in the last one used.

I would suggest you post the entire expression if you still get the
error after removing the previous IIf.