Solved

Crosstab: Multiple Column Headings to Group Data

Posted on 2009-05-11
6
387 Views
Last Modified: 2012-05-06
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
Comment
Question by:dglover
  • 4
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 250 total points
ID: 24358379
Not with Access 2003.  
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24358385
Going to give us a clue what is in Col1, Col2, etc.?
0
 

Author Comment

by:dglover
ID: 24358647
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 44

Expert Comment

by:GRayL
ID: 24359330
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
 

Author Comment

by:dglover
ID: 24359426
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
 
LVL 44

Expert Comment

by:GRayL
ID: 24359760
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question