• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

correct my where clause in Access Query

I want to filter the State field not including some of the states.  The following one is not working.  Any advise?

Is Not "NY" and "NJ" and "IL"and "WI"
0
jjxia2001
Asked:
jjxia2001
1 Solution
 
Neil RussellTechnical Development LeadCommented:
WHERE [state] NOT IN ( "NY","NJ","IL","WI")
0
 
jjxia2001Author Commented:
Thanks!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now