Crosstab: Multiple Column Headings to Group Data

I am looking for guidance on how ( if it is possible) to have a crosstab query where you could group the data using multiple column headings. I want to be able to show my data like this
               

                                Q1                         Q2                              Q3                                   Q4
                      Col 1, Col 2, etc         Col 1, Col2, etc        Col 1, Col2, etc             Col 1, Col2, etc
Row 1
Row 2
and on....

So essentially Quarter and each underlying column (col1, col2, etc) is a collumn header. I think Access only allows one column header but I really need to group by Quarter and then by these underlying column groupings
dgloverAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GRayLConnect With a Mentor Commented:
Not with Access 2003.  
0
 
GRayLCommented:
Going to give us a clue what is in Col1, Col2, etc.?
0
 
dgloverAuthor Commented:
Not sure why the colums data is relevant but here you go....Col1, col2 will be things like "Qty of Onsite Meetings", "Qty of Outbound Calls", "Qty of Conference Calls"
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
GRayLCommented:
Sometimes you can transpose the rows and columns and get something that will work.  And what might be in Row1, R0w 2, and on.?
0
 
dgloverAuthor Commented:
Hi GRayL
Thanks, that helps me also understand the nature of the question. Row 1,2, etc will be a long, long list of companies. Due to its length, transposing rows for columns isn't going to work. Thanks for the suggestion though.
0
 
GRayLCommented:
I see.  What you are trying to do is smush what is in fact a 3-D view of a situation into a 2-D view (cross tab).  I'm afraid it is not going to work.
0
All Courses

From novice to tech pro — start learning today.