Results 1 to 2 of 2
  1. #1
    lpdds is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    3

    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.

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Change OR to And

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Only pull out curtain data from a query
    By mela in forum Queries
    Replies: 0
    Last Post: 12-08-2009, 12:20 PM
  2. Use query to find and sum data
    By kwelch in forum Queries
    Replies: 3
    Last Post: 11-23-2009, 04:26 AM
  3. Form Data Not being passed onto query
    By fmoses in forum Queries
    Replies: 2
    Last Post: 08-20-2009, 08:33 AM
  4. Use form data in a query
    By Zholt in forum Forms
    Replies: 2
    Last Post: 05-13-2009, 07:59 PM
  5. data query question
    By mrayray09 in forum Queries
    Replies: 0
    Last Post: 01-20-2009, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums