Not Like

[GCLIFTON]

I do not know what i am doing wrong. I am trying to say show me everything that is not 666 in the Trans Code and does not contain the begining character of BR- and give me everything what is left. Need help on how to get the correct results not the ones below

[aytee111]

You have them as "OR" - if you look to the left of the design, that is what it says. To make it AND it must go on the same line.

[GCLIFTON]

When i place it on the same line it also excludes the data that has nothing in it as well. I am going from 1,000 line to 200 and there are only like 5 that begin with BR-

[aytee111]

Not's are very complicated for the human brain to process! Another way of doing it is to create a query that does the opposite, i.e. shows all the records that you don't want, then in your main query exclude all of those.

[JoeM]

Enter the following Criteria on the same line:
Under PENDING ACTIVITY: Is Null Or Not Like "BR-*"
Under TRAN CODE: <>666

[GCLIFTON]

That worked.