Dear Asha:
A crosstab has row headings, column headings, and intersections. You may
choose one of more for row headings, but only one for column headings and
one for intersections.
With this in mind, what is your question. Do you want multiple columns for
column headings? That's something I often wish to have. Do you want
multiple intersection columns. I do this occasionally, too.
But none of this can be done with a crosstab. There is an equivalent to a
crosstab which can do so, using subqueries. To make this work, I typically
code VBA to dynamically produce the SQL (or, more likely, I use a Stored
Procedure in an MSDE database).
If you'll provide a high level of detail, perhaps I can help.
Tom Ellison
