Extra row headers in Crosstab Queries?

[Evi]

I'm using Access 2000. Although the Crosstab Query Wizard limits me to 3
Rowheaders, I seem to be able to add more in Query Design view.
At the moment I've got 5 (not including the Totals column)

It seems too good to be true - it means for instance, that I can group my 12
month reports by year.

I've based a report on this query but am I laying up problems for myself by
adding the extra RowHeaders? The report looks OK at the moment, but have any
of you experienced problems doing this?

Evi

 

[John Spencer]

No, you should not worry about this aspect.

The wizards are limited and almost always use less items then are available.
For instance, you could have up to 255 columns of data in a report (not a
good idea, but it is possible). The report wizard will only work with 30 or
so before it will complain you have too many.


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Evi]

Thanks John, it'll save me a whole heap of work.
Evi