Solved

correct my where clause in Access Query

Posted on 2012-03-21
2
222 Views
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"
0
Comment
Question by:jjxia2001
2 Comments
 
LVL 37

Accepted Solution

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

Author Closing Comment

by:jjxia2001
ID: 37749580
Thanks!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

785 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