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!!