Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula (Access2k)

    You guys,
    How can I do all this using one formula (I wanna set value to tax.)??
    tax: IIf([Country] = "Ireland",[Fees] = 1, [currency] = "GBP" or [Country] = "UK" or [Country] = "Britain", [Fees] = 0.5,[Fees])

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Formula (Access2k)

    Hi,
    Try:
    tax: IIf([Country] = "Ireland",1, iif([currency] = "GBP" or [Country] in ("UK", "Britain"), 0.5,[Fees]))
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula (Access2k)

    Thanx Rory!
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15>

Posting Permissions

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