Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2006
    Location
    Charlotte, North Carolina, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Joining Multiple IIf Statemetns (Access 2003 SP1)

    I'm trying to create a column to populate with 3 conditions. See below. Can someone help??

    Method: IIf([Call Start] Is Not Null,"IVR") Or ([MinOfDate] Is Not Null & [Call Start] Is Null,"LMS") Or ([Call Start] Is Null & [MinOfDate] Is Null,"N/A")

  2. #2
    Star Lounger
    Join Date
    Nov 2005
    Location
    Edmonton, Alberta, Canada
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joining Multiple IIf Statemetns (Access 2003 SP1)

    Method: IIf([Call Start] Is Not Null,"IVR,iif([MinOfDate] Is Not Null & [Call Start] Is Null,"LMS", iif([Call Start] Is Null & [MinOfDate] Is Null,"N/A")))

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

    Re: Joining Multiple IIf Statemetns (Access 2003 SP1)

    To combine conditions, use AND instead of the concatenation operator &. And use the IsNull(...) function to test if a value is null:

    Method: IIf(Not IsNull([Call Start]),"IVR",IIf(Not IsNull([MinOfDate]),"LMS","N/A"))

Posting Permissions

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