Not statement

[Sam]

I have a query and need to exclude some'SKU" items. If I enter just one
exclusion it wil work but when trying to enter more than one it doesn't. I
know I have done this before but this time I'm stumped. I want to do this in
the SKU field:
Not B008 or 365* or I*
What am I missing??
Thanks!

 

[Tom Lake]

I have a query and need to exclude some'SKU" items. If I enter just one
exclusion it wil work but when trying to enter more than one it doesn't. I
know I have done this before but this time I'm stumped. I want to do this in
the SKU field:
Not B008 or 365* or I*
What am I missing??
Thanks!

Try

Not B008 And Not 365* And Not I*

Tom Lake

 

[Mark]

Put Not "B008 " in the first criteria line. Put Not "365" & * in the second
criteria line. Put Not "I" & * in the third criteria line.

Steve

 

[Sam]

That was it, thanks! I had a brain lapse!!!

Try

Not B008 And Not 365* And Not I*

Tom Lake