Multiple "Not Equal" Criteria

[CCRT]

What is the correct format to declare a multiple “Not Equal” criteria?


I’ve made a sample table that contains one field named “Color”
I’m querying the field using criteria of Not "Blue" Or "Red"

The query result only excludes the value “Blue” the value “Red” remained.

What an I doing incorrectly?


SELECT tblColor.Color
FROM tblColor
WHERE ((Not (tblColor.Color)="Blue" Or (tblColor.Color)="Red"));


Thanks for any help with this

--Dave

http://home.comcast.net/~ccrt-racing/ccrt.htm

 

[PaultheS]

Try this:

SELECT tblColor.Color
FROM tblColor
WHERE Not ((tblColor.Color)="Blue" Or (tblColor.Color)="Red");

 

[mp9]

SELECT tblColor.Color
FROM tblColor
WHERE tblColor.Color <> "Blue" AND tblColor.Color <> "Red";

http://www22.brinkster.com/accessory/

 

[jebry]

Hi Dave!

You can also do it like this:

SELECT tblColor.Color
FROM tblColor
WHERE tblColor.Color Not In ("Blue", "Red");

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[CCRT]

Thanks
They both work great.....

The later "mp9's" Is a little easier to input into a grid view criteria But the use of "Or" in "PaultheS" make more sense to me.

Oh well, thanks to both of you for such quick responses.

--Dave

http://home.comcast.net/~ccrt-racing/ccrt.htm