Filter by criteria

  • Thread starter Thread starter FERNANDO
  • Start date Start date
F

FERNANDO

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
 
Enter this in the Criteria row:
Like "ENG*" OR Like "PS*" OR Like "CS*"

Just a thought, but I'm wondering if there is something common to all the
entries that start with ENG? If so, consider whether this field is atomic
(contains only one piece of data - one of the basic rules of data
normalization), or if you have 2 things in the one field? If it's not
atomic, consider whether 2 fields would be better: one field containing the
type (ENG or PS or CS or ...), and the other field containing the other
info.
 
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
Click to expand...

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