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

[Deb0212]

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.

[Bob Fitz]

Try:

SELECT YourTableName.CustomerID
FROM YourTableName
WHERE (((YourTableName.BusinessCtr)=2 Or (YourTableName.BusinessCtr)=3));