Report based on Crosstab query

[Steve via AccessMonster.com]

I'm buiding a report (that has subreports, unfortuneately) that i had to
resource to a Crosstab query - when I try to make changes in design view, it
is REALLY slow - is there a work-around for this ? I don't think you can make
a table off a crosstab - I was thinking about exporting the crosstab results
to Excel, and then linking, but that seems too convoluted...

 

[Duane Hookom]

Set the Column Headings property in the crostab query to all possible column
heading values.

 

[ironwood9 via AccessMonster.com]

Thanks !

Set the Column Headings property in the crostab query to all possible column
heading values.

I'm buiding a report (that has subreports, unfortuneately) that i had to
resource to a Crosstab query - when I try to make changes in design view,

[quoted text clipped - 4 lines]

results
to Excel, and then linking, but that seems too convoluted...