Access 2k IDE grinds to a crawl with report based on CrossTab query

  • Thread starter Thread starter astro
  • Start date Start date
A

astro

Is there a reason why my mdb takes 15 seconds to open a simple report based
on a cross tab report? It takes another 20 seconds to save it, and just
switching between reports takes at least 5 seconds....saving a different
report takes the normal 1 second. Please note that I have decompled the mdb
file.

Thanks.
 
Open your crosstab in design view and view the properties. Type in the
possible column headings in the Column Headings property.
 
WOW -- what a difference!!!!

Thanks


Duane Hookom said:
Open your crosstab in design view and view the properties. Type in the
possible column headings in the Column Headings property.
Click to expand...
 
Back
Top