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
 
M

Marshall Barton

Cam said:
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"
Click to expand...


You could use:

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

or

Not IN("A123-847", "A123-878", "A123-232")
 
Top