Jim Dettman
jimdettman at earthlink.net
Mon Mar 7 07:54:58 CST 2005
Oh..one other you might bump into with a large number of Unions; the result set must be 1GB or less in size. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of ksklos at comcast.net Sent: Saturday, March 05, 2005 11:01 PM To: accessd at databaseadvisors.com Subject: [AccessD] Union Query Is there a limit to the number of sql statements you can have in a union query. I am using Access 2000. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com