By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Multiple criteria for a query are not working

P: 4
I've created a query to select voter registration records on a variety of criteria (all voters under 40 living in my city of a particular political party and who have voted in no more than 3 of the last 5 elections). When I enter each criterion individually, the query works. When I enter all the criteria, the query ignores all the criteria except one. What's happening? I'm using Access 2002 on Windows XP. Please help
Oct 2 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi jboisa, and Welcome to Bytes.

We'd need to see the SQL for your query before we can give an opinion on what might be wrong; please post this for us and I'm sure you will get a response back which helps you to identify the problem.

-Stewart
Oct 2 '08 #2

P: 4
Hi jboisa, and Welcome to Bytes.

We'd need to see the SQL for your query before we can give an opinion on what might be wrong; please post this for us and I'm sure you will get a response back which helps you to identify the problem.

-Stewart
I found the SQL for the query, and simply looking at that I figured out what the problem was and fixed it! Thanks for prompting me!

I have another problem, which I will post separately.

Thank You,

John
Oct 3 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.