Reports based on Crosstab

[Bdavis]

Is there some trick to doing this? I'm trying to creat a
report based on a crosstab query and seems just bog down
at every turn. For instance, after creating the report
using the report wizard which took way to long to begin
with, the sytem lock's up for five minutes everytime I
delete a field. I've never seen the sytem get totally
choked up in Report Design mode.

I know this is all pretty vague but, any idea what might
be happening?

 

[Duane Hookom]

If possible, open your query in design and view the query properties dialog.
Enter all of the possible column headings in the Column Headings property.

 

[Guest]

That did it. Thanks, that was incredibly helpful.

-----Original Message-----
If possible, open your query in design and view the query properties dialog.
Enter all of the possible column headings in the Column Headings property.

--
Duane Hookom
MS Access MVP
--




.