AnsweredAssumed Answered

How do I  write a script to exclude certain records?

Question asked by darinda@gmail.com on Jan 2, 2014
Latest reply on Jan 3, 2014 by 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

Outcomes