ron G Posted March 8, 2011 Posted March 8, 2011 I have a field: STATUS. It usually contains: "Current", "NPD", "Late", "Suspended", "Expelled", "Deceased" or "" I want to do a report that includes everyone who is NOT "Deceased" It doesn't seem that FM Perform Find does NOT allow '<>' or 'NOT=' or anything like it so I used: PERFORM FIND ["Current"] Extend Found Set ["NPD"] Extend Found Set ["Late"] etc... down to... Extend Found Set [""] The weird thing is that trying to extend to the found set to include blank or empty records does NOTHING??? If this is so, how do I include empty or blank STATUS values?? Thanks
ron G Posted March 8, 2011 Author Posted March 8, 2011 The 'right' solution was to CONSTRAIN not EXTEND the FOUND SET.... Thanks to the other related forum posts for leading me to that solution...
comment Posted March 8, 2011 Posted March 8, 2011 I want to do a report that includes everyone who is NOT "Deceased" How about doing exactly that - by a single request to omit "Deceased"?
Recommended Posts
This topic is 5009 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now