Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2013
    Posts
    82

    Unanswered: Another IF Statement

    I have this statement:

    =IIf([Forms]![Workorder]![Disposition]=6,”DISAPPROVE”,”APPROVE”)

    I would like to add another condition in addition to "6".

    So when item "6" or "7" is selected the result will be "DISAPPROVE".

    I appreciate the help.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    One option is to nest your Iif()s...

    Code:
    =IIf([Forms]![Workorder]![Disposition]=6,”DISAPPROVE”,IIf([Forms]![Workorder]![Disposition]=7,”DISAPPROVE”,”APPROVE”))
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Code:
    =IIf([Forms]![Workorder]![Disposition]=6 OR [Forms]![Workorder]![Disposition]=7,”DISAPPROVE”,”APPROVE”)


    Where, exactly, are you using this?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Aug 2013
    Posts
    82
    This is on a report.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Linq's solution is far better than mine! I had my head in Excel land this morning (I think it shows)
    George
    Home | Blog

  6. #6
    Join Date
    Aug 2013
    Posts
    82
    Thanks George and Missinglinq for your help. I opted for Linq's statement and works perfectly.

    Have a great day!

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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