Select Query for Category

J

jk

Hello,

I have a discount field which is populated with customer names to identify
the type of discount they receive.I run the query and i get all names but how
do i exclude a name for example.......exclude Alcoa or Coke from this query !
Thanks
 
R

RJ119

on the criteria line of your query put in Not "Alcoa" or "Coke"

This will give you everything but Alcoa and Coke
 
J

jk

hI,
The NOT statement works but when i use OR..........the query only removes
the first name........not alcoa....does not show up...... or coke......coke
shows up....what could cause the second one(coke) to ignore the "or"
expression???
Thanks
 
N

Neutron1871

Don't use or, use "and". If you use Or you are eliminating Alcoa "OR" Coke.
You want to eliminate Alcoa "AND" Coke.
 
Top