The expression you entered is too complex

[Ed J]

In designing a query I built an expression that contained
a nested if statement. And it worked fine. When I added
another if statement I suddenly get the message "The
expression you entered is too complex". What does this
mean? Is there another way of building it? Any ideas?

 

[Bill Crawford]

You can try using the IIF function in multiple calculated fields in sequence
and use the prev calc field name in each subsequent calc field expression.
If this doesn't work you may have to design several queries in sequence to
get the results.


food for thought:

I have a query to calc trees/ha which is fetched by another query to find
basal area (stump surface area), and a third query fetches query two to
calculate tree volumes for 2 cm tree diameter classes.

regards,

 

[tina]

you could try writing the expression into a public
function. then reference the function from the query. one
note, if you want the function to run for each record in
the query, pass a value to the function when you reference
it; you don't have to use the value in the function if you
don't need it, just passing it forces the function to run
on each record.

hth