I am trying to filter a report and am struggling to get the inverse of the if/then to show properly.
I have tested the 'equal to' formula and it is working properly. i.e. I set a filter to be equal to that word so it only pulls records with that word in the field I am referencing.
However, if I want the inverse of that report. i.e. I want all the records that do not contain that word to pull on the report however the inverse which I believe should just be switching the 'equal to' to 'not equal to' is not filtering the report at all. even though I have told the report to show me words not equal to the value I've entered are still pulling to the report.
I can make a work around with multiple 'equal to' lines. I just believe that selecting the inverse of equal to should pull the records properly.
TIA,
Kbarry
