Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Build query field (2003)

    Building a field based on IIF statement to fill the field with result. Works fine for only one IIF being true. Want to build field with result of two IIF being true
    qsata: IIf([gb250]>0,[gb250] & "-250GB",IIf([gb500]>0,[gb500] & "-500GB",IIf([gb750]>0,[gb750] & "-750GB")))
    Current sample result: 2-250GB Fills field using OR
    Looking for possible result: 2-250GB 2-500GB Need to fill field using AND

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

    Re: Build query field (2003)

    I'm not sure I understand what you're asking, but perhaps this will do what you want:

    qsata: IIf([gb250]>0,[gb250] & "-250GB") & IIf([gb500]>0," " & [gb500] & "-500GB") & IIf([gb750]>0," " & [gb750] & "-750GB")

    If not, please provide a more extensive explanation of what you want.

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Build query field (2003)

    That string modification works. Thank you.

Posting Permissions

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