Barbara Ryan
BarbaraRyan at cox.net
Thu May 29 14:16:45 CDT 2003
I have an Access 97 report that runs VERY slowly (I mean, like an hour or more at times!). Any suggestions you can offer would be greatly appreciated. The report header contains 5 subreports. The detail section contains 7 subreports. Each subreport contains,on average, appr. 3 detail lines and 1 total line. There are appr. 36 calculated fields per subreport. There are 54 calculated fields in the detail section of the main report --- SO, 36 x 7 subreports + 54 = 306 calculated fields in each detail section of the report. Each detail section is printed on a new page. The report is often more than 100 pages. There are appr. 20 tables used in the various queries of the main report and subreports. The client needs all of this info in one report. It is their Proposal that they submit when bidding on a contract, containing all of the labor rates, fringe benefits, overhead, profit, etc. for each union trade and level (i.e., carpenter foreman, carpenter journeyman, etc.) for straight time/overtime/double time for first shift, second shift, third shift. Help! Barb Ryan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030529/1d2096a2/attachment.html>