Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Nesting IIF statements (Access 03 SP2)

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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Nesting IIF statements (Access 03 SP2)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •