Find Entries Missing Certain Criteria

[scolivas]

I am pulling a query of people who have numbered designations. They can have more than one of these numbered designations. I am wanting to know wich of these people are missing the number 2 destignation all together.

Using the "not 2" isn't working because some of the people have the 2 and other designations, and when I use the "not 2" it only eliminates the record showing a 2, and leaves the rest of them showing, making it look like everyone is missing the 2 designation.

I am sure this is going to be very simple...but my mind is not functioning properly today.

thanks!

[NeoPa]

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.

[NeoPa]

I am sure this is going to be very simple...but my mind is not functioning properly today.

This won't be remotely simple unless you provide the relevant information in your question. We need to have a clue what sort of data you're working with before we can provide a helpful answer.
A good start would be the table MetaData. Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time