correct my where clause in Access Query

Posted on 2012-03-21
Medium Priority
Last Modified: 2012-03-21
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"
Question by:jjxia2001
LVL 37

Accepted Solution

Neil Russell earned 800 total points
ID: 37749218
WHERE [state] NOT IN ( "NY","NJ","IL","WI")

Author Closing Comment

ID: 37749580

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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.

Join & Write a Comment

I came across an unsolved Outlook issue and here is my solution.
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question