Hello,
I am working within a Link Query and have several filters I've put in.
"WHERE ([Contract #] NOT LIKE "") AND [Acct Code] NOT LIKE '72801011*' AND ([Pay Status] NOT LIKE 'L')"
Now I would like to add another criteria essentially saying, "exclude if Acct begins with 1234 and Contract begins with 9876". But only if they both appear in one line item.
I am working within a Link Query and have several filters I've put in.
"WHERE ([Contract #] NOT LIKE "") AND [Acct Code] NOT LIKE '72801011*' AND ([Pay Status] NOT LIKE 'L')"
Now I would like to add another criteria essentially saying, "exclude if Acct begins with 1234 and Contract begins with 9876". But only if they both appear in one line item.