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"
jjxia2001Asked:
Who is Participating?
 
Neil RussellConnect With a Mentor Technical Development LeadCommented:
WHERE [state] NOT IN ( "NY","NJ","IL","WI")
0
 
jjxia2001Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.