ron G Posted March 8, 2011 Share 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 Link to comment Share on other sites More sharing options...
ron G Posted March 8, 2011 Author Share 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... Link to comment Share on other sites More sharing options...
comment Posted March 8, 2011 Share 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"? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4792 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