<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=572503322-29052003><FONT face=Arial color=#0000ff size=2>Hmmm,
few things to look into. First, make sure you have indexes on everything
that you can, where searches are being used. (IE, if you are pulling
information from a list, and you only want records that have 'Something' in that
field, then you should have an index on the field.). I would recommend no
more then 3 or 4 indexes per table.....make them count.</FONT></SPAN></DIV>
<DIV><SPAN class=572503322-29052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=572503322-29052003><FONT face=Arial color=#0000ff size=2>That
should speed things up quite a bit (indexes make a BIG difference). Next,
are you connecting to a Back End source? If so, try running the Backend
locally, see if that helps. If it does, there may be some network issues
involved.</FONT></SPAN></DIV>
<DIV><SPAN class=572503322-29052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=572503322-29052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Barbara Ryan
[mailto:BarbaraRyan@cox.net]<BR><B>Sent:</B> Thursday, May 29, 2003 2: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>