Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Queries

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-16-2009, 07:53 AM
lpdds lpdds is offline Windows XP Access 2003 (version 11.0)
Novice
 
Join Date: Nov 2009
Posts: 3
lpdds is on a distinguished road
Default Excluding data in a query

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.
Reply With Quote
  #2  
Old 12-16-2009, 05:06 PM
Rainlover Rainlover is offline Windows XP Access 2003 (version 11.0)
Competent Performer
 
Join Date: Nov 2009
Posts: 173
Rainlover is on a distinguished road
Default

Change OR to And
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


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


All times are GMT -8. The time now is 01:26 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.