query criteria help?

  • Thread starter Thread starter Cam
  • Start date Start date
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.
 
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
Selecting latest revision but with criteria... 12
Customizing An Access Query 1
Summing Problem 2
Counting number of records within a query 4
finding unique values 3
Bill of material type query 3
Comparing two names 3

Back
Top