If Then Statement

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jojo De Castro
    New Member
    • Mar 2012
    • 1
    #1

    If Then Statement

    Hi!

    I have a query in access with 2 column. In Excel my formula would be :
    Code:
    =if(or(col 1="true", col 2="true"),"exempt","")
    What can I use in Access to achieve the same result?
    Last edited by NeoPa; Mar 28 '12, 04:30 PM. Reason: Converted to a valid question.
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      The IF function in Access is IIF. There is no OR function but you can use OR like an operator.

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32648
          #3
          Something like the following I expect :
          Code:
          =IIf([Col 1] Or [Col 2], 'Exempt', '')

            Comment

            Previous template Next
            Working...