Select query help!

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

KimberlyC

I'm trying to run a select query (Access 2000) to show only the orders
(from one table) in all states excepts SC and FL.
What is the criteria that I enter in the States filed of the query to get
this result?
Thanks in advance for your help!!

Kimberly
 
One method is:

Not In ("SC","FL")

You can also use an alternative of:
<> "SC" AND <> "FL"
 
Back
Top