IIF queries

[StephenD]

Hi,

I'm performing a nested iif calculation-it seems to hit a limit at 12 then it says 'expression you entered is too complex'
Anybody got any ideas?


Thanks,

StephenD

 

[Fornatian]

In excel you can nest up to 7 if statements and then it won't work. Access is probably much the same. One way around it is to use other functions like Choose and Swicth to make choices for you? Maybe a different approach would be to build a custom function and include that(which could accept field values as arguments) as a column header in a query.

Ian