![]() |
|
|
#1
|
|||
|
|||
|
I have a table containing a list of colors that I would like to run a query on. I want to exclude two or more colors from the results. In the query criteria, I have written <> "Red" OR <> "Blue". When I run the query both "Red" and "Blue" appear. I know this is very simple question but I cannot get it to work. Thanks.
|
|
#2
|
|||
|
|||
|
Change OR to And
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Only pull out curtain data from a query | mela | Queries | 0 | 12-08-2009 09:20 AM |
| Use query to find and sum data | kwelch | Queries | 3 | 11-23-2009 01:26 AM |
| Form Data Not being passed onto query | fmoses | Queries | 2 | 08-20-2009 06:33 AM |
| Use form data in a query | Zholt | Forms | 2 | 05-13-2009 05:59 PM |
| data query question | mrayray09 | Queries | 0 | 01-20-2009 05:41 AM |