I have to do a query but don't know how to put in the criteria for one of the fields indicating a type of order. The values in this field are either 1, 2 or 3. I want to find all the orders for customers who have a 2 or a 3, but do not have 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.
Bookmarks