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

ANY and ALL Clauses in Where

P: 1
Hi
Can anyone help me telling if we can use ALL or ANY clauses in the WHERE clause of a SELECT statement in Access? If we can not, how can we get the same functionality in Access?
May 30 '07 #1
Share this Question
Share on Google+
2 Replies

Rabbit
Expert Mod 10K+
P: 12,441
Hi
Can anyone help me telling if we can use ALL or ANY clauses in the WHERE clause of a SELECT statement in Access? If we can not, how can we get the same functionality in Access?
How is ALL and ANY used?
May 31 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi
Can anyone help me telling if we can use ALL or ANY clauses in the WHERE clause of a SELECT statement in Access? If we can not, how can we get the same functionality in Access?
I'm afraid they are not available.

We use a combination of Joins and checking for null and not null matching. If you let us know what you are trying to do we will try to help you build it.
Jun 1 '07 #3

Post your reply

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