• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

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
0
dglover
Asked:
dglover
  • 4
  • 2
1 Solution
 
GRayLCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now