Performance Problem

J

JF Bouthillier

Hi all,

I have a report based on only 1 table. Both the table and the report have
more than 40 fields (some quite long) with textboxes and combo boxes.

The performance of the report is really bad. Please help to improve it.

Thanks a lot.
 
D

Duane Hookom

1) index any fields used to filter or sort
2) remove any [Page] of [Pages] text boxes
3) change the combo boxes to text boxes and include
the Row Source tables in the report's Record Source
4) tell us if the query takes a long time to display all records or
is the report the only object that takes long to display
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weigh tasks 0
Re-title multiple MS Project .mpp files at once 0
Appending tables 0
Form filter with multi-column combo box does not work in report 0
Problem Filtering Report data 1
How to get report to only show <85% 3
Form filter with multi-column combo box in report 0
Using Subreports to create a Main Report 1

Top