Speeding up a report

  • Thread starter Thread starter Kath via AccessMonster.com
  • Start date Start date
K

Kath via AccessMonster.com

I have a master report with 3 subreports which groups on a Site and is
filtered by a Prompt of a Bill Date. This report is taking forever - is
there anything I can do to speed up a report that is using a total of 4
queries (which some of those reference other queries as I am totaling based
on aggregated services and payments, etc. which are from multiple tables?)
 
You don't mention how long it takes the individual/separate queries to run.
Is this slowdown true of the underlying queries, or only when you combine
them into the report?

Are all the fields you use to join, select, group by and sort already
indexed in the underlying tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
don't use "pages" to get "page 1/30". That slows down
reports, and particularly slows down the first page of
reports.
 
The queries run ok, the fields used to link are all indexed. I tried removing
the "pages" and this did improve the report performance significantly.

Thanks!!
Kathie
 
Back
Top