It takes hours to save my query as a report. Any reasons why?

[Guest]

I created a crosstab query to analyze sales data. It takes about 15 minutes
to run the query and several large tables are linked. When I tried to save
this query as a report, it took hours for it to generate the report format.
When I tried to select Design view to modify it, an hour glass appeared, and
it won't let me select any controls. Any ideas what might be causing this
problem?

 

[Duane Hookom]

I think most of your issues would go away if your crosstab query had defined
columns in the Column Headings Property.