<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks, John..... I think that's a good idea.
I'll give it a shot!...........Barb</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=papparuff@attbi.com href="mailto:papparuff@attbi.com">John Ruff</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 29, 2003 3:47
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] VERY SLOW report
</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>