Exclusion Logic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the WHERE syntax to exlude records meeting criteria accross two
fields. The best way to explain what I am trying to accomplish to provide a
simple example

STATE RATE
AL 1.5
AL 2
MO 1
MO 2
AL 1

I want to exlude all records where state = "AL" and Rate <=1.5. Records not
meeting this criteria should be returned as part of my query.
 
I think I have answered my own question. Looks like this should actually be
an "OR" operation as opposed to an "AND" operation. This WHERE function
returns the desired results:

WHERE ([rate]>"1.5") OR ([STATE]=AL)
 
What is the WHERE syntax to exlude records meeting criteria accross two
fields. The best way to explain what I am trying to accomplish to provide a
simple example

STATE RATE
AL 1.5
AL 2
MO 1
MO 2
AL 1

I want to exlude all records where state = "AL" and Rate <=1.5. Records not
meeting this criteria should be returned as part of my query.
Click to expand...

SELECT <whatever>
FROM tablename
WHERE NOT (State = "AL" AND [Rate] <= 1.5);

or, equivalently,

SELECT <whatever>
FROM tablename
WHERE [State] <> "AL"
OR Rate > 1.5;

John W. Vinson[MVP]
 
Back
Top