2 Replies Latest reply on Jan 3, 2014 8:44 PM by darinda@gmail.com

    How do I  write a script to exclude certain records?

    darinda@gmail.com

      Title

      How do I  write a script to exclude certain records?

      Post

           I'm moving from Bento to Filemaker PRO 12.

           In Bento I have a "report" I made in Bento that Finds all my clients from last year (2013) and excludes any that are sold for this year (2014).

           Basically I want my script to work thus: 

           If Status 2013 is equal to Sold AND Status 2014 is NOT EQUAL TO "Sold" and Status 2014 is NOT EQUAL TO  "No" 

           However, I'm not able to figure out how to do a Not Equal to function in the scripts... 

            

           Thanks in Advance