[AccessD] Number of 'OR's in queries - what's the limit?

Dan Waters dwaters at usinternet.com
Tue Jul 24 14:10:05 CDT 2007


2003 is also 99.  

But, using WHERE PKID IN (1,2,4,8, ...) looks like there will be no limit.
We'll find out.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Tuesday, July 24, 2007 1:23 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?

I found it in A97 and A2002...search help for 'Specifications'...in 97 its 
query specs...and in 2002 its access specs...97 is 40...2002 is 99.

I don't have 2003 to look.

Good Luck,

Mark A. Matte


>From: "Dan Waters" <dwaters at usinternet.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?
>Date: Tue, 24 Jul 2007 12:31:31 -0500
>
>That's a good plan!  I was hoping to do a customer update within the next
>half hour though.
>
>I was hoping that someone had seen some documentation on this.  The number
>40 was documented 'somewhere' in Access help.
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>Sent: Tuesday, July 24, 2007 12:13 PM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?
>
>You could reasonably quickly set up a test to find out by building a 
>dynamic
>query, a string such as select PKID from tblX where (PKID=1 or PKID=2
>or...).  Add 10 (or 100) at a time and see how far you get.
>
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
>Sent: Tuesday, July 24, 2007 1:02 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Number of 'OR's in queries - what's the limit?
>
>In Access 97, there was a limit of 40 OR words in a query.  There is a 
>limit
>in Access 2003, it's >250, but I don't know what it actually is.
>
>Does anyone know?
>
>Thanks!
>Dan
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
http://newlivehotmail.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 
























































































































































































More information about the AccessD mailing list