<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=338364019-29052003><FONT face=Arial color=#0000ff size=2>I
believe you have answered your own question. So many subreports and
calculations. If your main report and/or the subreports are based on
queries, this might be the case where you could look at creating temp tables
through Make Table queries. You could also add some of the calculations in
the Make Table queries so that they are stored in the temp tables. Your
main/sub reports could then be based on these temp
tables.</FONT></SPAN></DIV>
<DIV><SPAN class=338364019-29052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=338364019-29052003><FONT face=Arial color=#0000ff size=2>And
for those who are grimacing when I say temp tables and storing calculated values
<gr>, sometimes they are a necessary evil to speed up the program.
In my way of thinking, taking around an hour or to generate a report is way too
long.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><B><I><FONT face="Times New Roman" color=#0000ff size=4>John V.
Ruff</FONT><FONT face="Times New Roman" color=#008080 size=4> – The Eternal
Optimist</FONT><FONT face="Times New Roman" size=4></FONT> <FONT face=Wingdings
color=#800080 size=4>J</FONT></I></B><I></I> <BR><I><FONT
face="Times New Roman">Always Looking For Contract Opportunities</FONT></I> </P>
<P><FONT face="Times New Roman" size=2>Home: 253.588.2139</FONT> <BR><FONT
face="Times New Roman" size=2>Cell: 253.307.2947</FONT> <BR><FONT
face="Times New Roman" size=2>9306 Farwest Dr SW</FONT> <BR><FONT
face="Times New Roman" size=2>Lakewood, WA 98498</FONT> </P>
<P><B><I><FONT face="Times New Roman" color=#000080 size=2>“Commit to the Lord
whatever you do,</FONT></I></B> <BR><B><I><FONT face="Times New Roman"
color=#000080
size=2>
and your plans will succeed.” Proverbs 16:3</FONT></I></B><I></I> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Barbara
Ryan<BR><B>Sent:</B> Thursday, May 29, 2003 12:17 PM<BR><B>To:</B> Access
List<BR><B>Subject:</B> [AccessD] VERY SLOW report <BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The report is often more than 100 pages.
There are appr. 20 tables used in the various queries of the main report and
subreports.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Help! </FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV></BLOCKQUOTE></BODY></HTML>