Scripting constraining found set with multiple = and ≠ requests?
I have a database, of which a percentage are members, and I want to script membership lists of those who live in New England and those who do not. The first part was easy.
To script finding the NE members I created a new script, called a script that finds all current members and sorts them by name, then constrained the found set:
Perform Script ["Sort Membership List"] Constrain Found Set [Restore]
In the Constrain step I have
Action: Find Records Criteria: State: [=MA], [=CT], [=RI], etc.
This works fine for finding everyone who is a member and lives in New England, but when I change the = to ≠ and run the script it says "No records match these find criteria." Is there a way to do this?