Results 1 to 2 of 2
  1. #1
    SpdRacerX is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    40

    "IIf" "AND/OR" Expression Problem

    Having trouble with the expression builder in a form.



    I have this so far which works fine:

    =IIf(IsNull([Child156].[Form]![Outcome]),"Open","Closed")

    As does this:

    =IIf([Discharge Type]="General","Open","Closed")

    What I want to do is to combine the two IIf statements into the same Text Box on a form.

    Any help would be appreciated.

  2. #2
    SpdRacerX is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    40
    Figured it out on my own I think!

    =IIf(IsNull([Child156].[Form]![Outcome]) And [Discharge Type]="General","Open","Closed")

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 01-11-2012, 12:34 PM
  2. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  3. Replies: 8
    Last Post: 08-05-2011, 02:55 PM
  4. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  5. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums