NOT expression in a Query

  • Thread starter Thread starter Terry Hollands
  • Start date Start date
T

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!
--
 
Thanks that worked fine
--



NG said:
Hi Terry

<>"Red" AND <>"Orange"

gr
NG

Terry Hollands said:
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!
Click to expand...
Click to expand...
 
Back
Top