How do I create an expresion to exclude two items or NOT EQUAL to.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying exclude two item in a query that I am using. How do I do this in
Access 2002?
 
Jamie said:
I am trying exclude two item in a query that I am using. How do I do this in
Access 2002?
Click to expand...

Try this:
In the criteria field, put:
<>"name of 1st item" And <> "name of 2nd item"
 
No idea. You might want to tell us What two items you are trying to
exclude.

Since you did not give us a specific question, we can't give you a specific
answer. The short answer is...

Under that field in your query, put...

Not "some item here" and Not "some other item"
 
Jamie said:
I am trying exclude two item in a query that I am using. How do I do this in
Access 2002?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The items are stored in the column_name. You just set up your criteria
to exclude them:

WHERE column_name Not In ('item1', 'item2')

If the items are numeric data types remove the quotes. If they are Date
data types replace the quotes with #.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAYH5IechKqOuFEgEQJH3QCePjQKL5BIngDgX3RBSrqTzbp0IjoAnR75
meUpGWqGK6vhvt6uk177OrWp
=XEgk
-----END PGP SIGNATURE-----
 
Back
Top