Defining Criteria

[MaineLady]

I have a database in which 1 column has a multitude of codes. The codes are...


S, C, O, A, J, eMail, and several that start with the letter "N".

I want to create a query that will give me all of the records except the ones coded A, J, and eMail.

How do I do that?

[Bob Fitz]

Open the query in design mode.

In the Criteria row of the column withe the codes put: <>"A" And <> "J" And <> "eMail"

[Minty]

Or as an alternative that might be easier to read, in the criteria put

Not In ("A","J","eMail")