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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I think most of your issues would go away if your crosstab query had defined
columns in the Column Headings Property.
 
Back
Top