query criteria help?

C

Cam

Hello,

How do I put in the criteria in the SQL query design view to filter the
records that do not equal three product number. I put this, but does not work.
<> "A123-847" OR "A123-878" OR "A123-232"

I guess the criteria must be wrong.
 
J

Jeff Boyce

Cam

I suspect what you want would be the records where the product number is not
"A123-847" and is not "A123-878" and is not "A123-232".

A couple ways to do this:

Not In("A123-847","A123-878","A123-232")

or

<> "A123-847" AND <> "A123-878" AND <> "A123-232"

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Count in Sigma Query 3
Summing Problem 2
Customizing An Access Query 1
Counting number of records within a query 4
Access Dcount (multiple criteria) 3
Bill of material type query 3
Parameter Query multiple criteria help 6
access 2007 criteria in query 2

Top