Results 1 to 2 of 2
  1. #1
    Deb0212 is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2012
    Location
    Hickory, PA
    Posts
    1

    Question Query Criteria - looking for records that contain some things, but not another.


    Hello. I have to do a query but don't know how to put in the criteria for one of the fields (BusinessCtr) indicating a type of order. The values in this field are either 1, 2 or 3. I want to find all the customers (CustomerID) who have a 2 or a 3, but who have never had a 1. I don't do a lot of queries, and I usually don't have to do this type. Any help would be greatly appreciated. Thank you in advance for your help.
    Last edited by Deb0212; 07-01-2012 at 09:32 AM.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Try:
    Code:
    SELECT YourTableName.CustomerID
    FROM YourTableName
    WHERE (((YourTableName.BusinessCtr)=2 Or (YourTableName.BusinessCtr)=3));
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 10
    Last Post: 01-27-2012, 01:35 PM
  2. Query Criteria not returning any records
    By SgtSaunders69 in forum Access
    Replies: 2
    Last Post: 12-19-2011, 07:45 PM
  3. Replies: 3
    Last Post: 10-25-2011, 11:38 PM
  4. New server breaks things
    By blinks in forum Access
    Replies: 1
    Last Post: 03-05-2011, 01:52 AM
  5. Things moving around on my form
    By jlm722 in forum Forms
    Replies: 0
    Last Post: 09-30-2009, 03:34 PM

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