Access Reports VERY slow to display

[Malia]

Does anyone know why it would take almost 1 full minute for a report in
Access 2007 to display? It also takes just as long to work in Design View to
make simple changes.

 

[Allen Browne]

If you have not yet done so, download Service Pack 2 for Office 2007 from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en

SP2 probably includes the earlier hotfixes that address this kind of thing.

If that does not solve the problem, tell us a bit more about this report. Is
it based on a crosstab query? If so, specifying Column Headings may help:
http://allenbrowne.com/ser-67.html#ColHead

Or is it based on attached tables?