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

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.
 
D

Duane Hookom

Open your crosstab in design view and view the properties. Type in the
possible column headings in the Column Headings property.
 
A

astro

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...
 

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

Crosstab in a Subreport running slow...not due to dynamic headings 2
CrossTab Query Access Report - 1
minor changes in Report Design View take a long time 2
Report based on Crosstab Query 3
Report Based on Crosstab Query 4
Report Query Works 2nd Time, But Not 1st 14
Crosstab query based Reports 1
Access report; Cosstab query 1

Top