Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    RTP, NC, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nested IIF Statement (A97)

    I'm trying to put together a nested IIf statement and am having a bit of syntax trouble. The statement is going in a textbox on a subreport. There are two fields in the subreport that I'd like to evaluate: EstimDate and Status. I would like for a text string "Additional Correspondence:" to be displayed if EstimDate is not null, OR if Status = "M7" (which is just a status category). I already had the syntax correct for the evaluation of the EstimDate portion of this,
    (=IIF (IsNull ([EstimDate]), " ", "Additional Correspondence:") but have recently added Status="M7" as another criteria, and don't know exactly how to nest it.

    Any Ideas?

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

    Re: Nested IIF Statement (A97)

    Try

    =IIf([Status]="M7" Or Not IsNull([EstimDate]), "Additional Correspondence:", "")

Posting Permissions

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