Not statement

S

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!
 
T

Tom Lake

Sam said:
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!
Click to expand...

Try

Not B008 And Not 365* And Not I*

Tom Lake
 
M

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
 
Top