<!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 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>