Jim Lawrence (AccessD)
accessd at shaw.ca
Fri May 21 05:56:34 CDT 2004
Hi Martin: Check out: http://www.databaseadvisors.com/newletters/newsletter112003/0311UnboundRepor ts.htm (watch for wrap) The article desribed a process that handled 500 page reports on a regular bases. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid Sent: Thursday, May 20, 2004 11:29 AM To: Access Developers discussion and problem solving Subject: [AccessD] Reports What sort of time would I expect when moving from Page 1 to Page 500 in a report. i.e cliecking to go to the last page?? Fairly complex report which is pulling data from SQL Server using a Stored procedure. Opens in under 2 seconds but still takes forever to move to the last page. Given I need to move very quickly from page 1 to page 500 would it be better to create an populate a local table with the date and take the hit before the form loads?? Comments?? Martin -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com