design view changes very slow

[LAB]

I am using a crosstab query to create a report, and the column headings are
labeled appropriately. when i try to add a field to the report in design
view or make any changes to the fields it is very slow.

 

[John Spencer MVP]

You can speed this up if you know all the names of the columns to be generated
by the PIVOT statement.

In the crosstab query, list the column names in the pivot clause. Something
like the following.

TRANSFORM ...
SELECT ...
FROM ...
WHERE ...
GROUP BY ...
HAVING ...
PIVOT SomeMonthNameField in ("January","February","March",...,"December")

If you can't work in the SQL view, then in the query's Column Headings
property enter the column names that are generated by the cross tab query.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County