OK, here is the problem.

I created a crosstab query to give me the count of a field called 'status' (6 choices) in the row header, then put the 'contractor' field in the column header (6 contractors).

When run as a crosstab query, it takes about 5 seconds, nb there are 17,000 records.

I thought OK, if a bit slower than I would have liked, so I then tried to build a report based on this crosstab query, essentially just so i could add the company logo etc to the top and reformat it so the contractors were in the report header.

Even when I try to open this in design mode and move a field or do anything, it takes ages to do anything.

I expected it to be slow when it was being opened in preview mode, not in design mode though?

Any ideas or suggestions for other methods of doing this?

Would it be better to do some kind of dcount, if you can evaluate more than one condition? Or would separate queries be better, but then I may miss a new contractor!

All suggestions gratefully received!!

Hi,

While you're designing the report you can use a trick to make it faster:
1) Create a new query and add the crosstab query that is used as recordsource for the report
2) Change it to a make table query to create a temp table with a name like "tmpMyReportName"
3) Change the report's recordsource to the new temp table
4) After you finish the report's design you can delete the temp table and revert the report's recordsource back to the original query.

Hope this helps.