Nesting IIF statements (Access 03 SP2)

Topic

New Reply

Do you know how many IIF statements can be nested in one expression?

Reply | Quote

Replies

You can nest pretty deeply, but you run the risk that
a) the expression becomes too complicated for Access to evaluate, and
the expression becomes impossible to understand and to maintain.

If you really need to nest deeply, consider an alternative such as the Choose Function or Switch Function, or write a custom VBA function.

Reply | Quote