filter by criteria

External Since: May 27, 2009 Posts: 1

I have a query that is extracting an inventory list, but the first field
called Part_Nbr, I need to exclude items that start with "ENG", "PS", "CS",
I could only get it for 1 criteria with NOT LIKE "ENG*", but I do not know
how to include the others.
I would appreciate your help.

Thanks

Fernando

External Since: Nov 28, 2008 Posts: 104

On Wed, 27 May 2009 21:19:31 -0400, "FERNANDO" wrote:

>I have a query that is extracting an inventory list, but the first field
>called Part_Nbr, I need to exclude items that start with "ENG", "PS", "CS",
>I could only get it for 1 criteria with NOT LIKE "ENG*", but I do not know
>how to include the others.

NOT LIKE "ENG*" AND NOT LIKE "PS*" AND NOT LIKE "CS*"