Can this be done?
I need to run a monthly report and the status of individuals can be either active, pending, drop or sample.
Can I run a find using multiple search criteria, active and pending, or do an omit - drop and sample. I want both the active and pending individuals in the report.
It seems when I do the first find/omit and try to do a find or omit on the subset of records, the find operation seems to be applied on the entire database and not the the subset.
Can this be done? How?
Thanks in advance.