Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    EZ IIF( Q (v2KSR1)

    I searched hi and lo for a different route but with no luck. Consider this IIF( statement:
    IIf([wow]="a" Or [wow]="b" Or [wow]="c","abc","xyz")
    Is there a way to recreate this statement without repeating the "[wow]=" ?
    I know this won't work:
    IIf([wow]="a" Or "b" Or "c","abc","xyz") but is there a different approach?
    Thanks!!

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: EZ IIF( Q (v2KSR1)

    Try using IN keyword. Example:

    IIf([Wow] In ("A","B","C"),"ABC","XYZ")

    HTH

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EZ IIF( Q (v2KSR1)

    Outstanding Mark! Thanks a bunch...it worked perfectly!! Have a great weekend.

Posting Permissions

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