NOT expression in a Query

[Terry Hollands]

I have a database that I need to query. In one column I have the field name
ROUTE and the data entries are in colours [Red, Yellow, Orange etc] I want to
query the database and exclude the Red and the Orange routes.

I have tried typing in:
Not "Red"
Not "Orange"

However this does not seem to exclude the colurs in the query. Where am I
going wrong? Please!
--

 

[Allen Browne]

Try:
Not IN ("Red", "Orange")

Note that this excludes nulls also.

 

[NG]

Hi Terry

<>"Red" AND <>"Orange"

gr
NG

 

[Terry Hollands]

Thanks that worked fine
--

Hi Terry

<>"Red" AND <>"Orange"

gr
NG

I have a database that I need to query. In one column I have the field name
ROUTE and the data entries are in colours [Red, Yellow, Orange etc] I want to
query the database and exclude the Red and the Orange routes.

I have tried typing in:
Not "Red"
Not "Orange"

However this does not seem to exclude the colurs in the query. Where am I
going wrong? Please!