how to group column headings in crosstab query

[Guest]

I have a crosstab query in which row heading is the cost centre name, values
is sales amount and the column heading is the quarter of the year.

i need to group this column for e.g.
Qtr1 QTr2
Jan Feb Mar Apr May Jun

Now how do i make this kind of format using crosstab query since the Main
Group(qtr1) should involve the name of the months as its sub group i.e. first
row should b qtr1, second row should b the name of the months n the third row
should b the values i.e. sale amount.

i would really appreciate ur help
thanx binny

 

[Duane Hookom]

You can't have more than one heading in a crosstab query. If you are
displaying this in a form or report, you can just add more labels for the
quarters. Otherwise you need to provide more information.