3 Replies Latest reply on Aug 29, 2012 11:42 PM by Sorbsbuster

    Help using an 'AND' in a formula

    RachelJacobsen

      Title

      Help using an 'AND' in a formula

      Post

      This works:

      If ((Table1::type)="TypeOfLetter"; "Attempted to give the "& Letter1 & ". " & " Knocked on the door, no one answered. Therefore, the " & Letter1 &  " was mailed to " & PersonMailedTo & " on " & DateMailed & ".")

      I want to add another condition: 

      If ((Table1::type)="TypeOfLetter" and if (Table2::Type); "Attempted to give the "& Letter1 & ". " & " Knocked on the door, no one answered. Therefore, the " & Letter1 &  " was mailed to " & PersonMailedTo & " on " & DateMailed & "."))

       

      Any ideas where I can get some samples using multiple conditions