Hello all,
I’m hoping to get some help with a query. The query is pulling data from a payables table and I am trying to add criteria that will ignore a specific text string in the Description field of the source table.
Here is an example of what I want it to ignore:
ABC*Open Item Inc~
I tried using Not Like “ABC*Open Item Inc~“, but the query not only ignores the string shown above but it also ignores anything with ABC or Open or Item….etc. I cannot seem to come up with the criteria that will allow the query to only ignore anything with the entire string and not just any part of the string.
Additional note: I know the wildcard character is present in the text string, and there is nothing I can do about that as the source data is coming from an outside party.
Any ideas would be appreciated.
Thanks,
Pete