How many nested iff can be there in iff function?

[Jeff Boyce]

Use the large white space beneath the subject field to provide a more
specific description.

The number of nested IIF()s probably depends on the complexity of the
expression(s) embedded within the IIF() statements. How many are you trying
to nest? What happens when you do that? Have you checked Access HELP for
this function?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

I'm not aware of a limit in number of nests - the limit will probably be
either "Query Too Complex" or the expression being too large, and will vary
with the details of your expression.

If the question arises, though, then nested IIF's are probably not the best
solution for the problem; a Query joining to a lookup table, or a call to the
Switch() or Choose() functions, or a custom VBA routine may be better.

 

[Duane Hookom]

Any time I see nested IIf()s, I get the feeling you are avoiding using data
to model your business rules/calculations.

Duane Hookom
MS Access MVP