Select Query for Category

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
on the criteria line of your query put in Not "Alcoa" or "Coke"

This will give you everything but Alcoa and Coke
 
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
 
Don't use or, use "and". If you use Or you are eliminating Alcoa "OR" Coke.
You want to eliminate Alcoa "AND" Coke.
 
Back
Top