Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 47
  • Last Modified:

How can I get the cross tab shown in the example from table shown in example?

Please see the attached sheet.  Is there a way in Excel, Access or other to get from table on the left to cross-tab on the right?  This is just an example.  The actual table is more than 1MM rows.  Thanks.
EE.xlsx
0
tomfarrar
Asked:
tomfarrar
  • 3
  • 3
1 Solution
 
PatHartmanCommented:
On the right are THREE crosstabs not one.  You just have to create them one at a time.  If you want them all on the same report, embed them as subreports.
0
 
tomfarrarAuthor Commented:
Can this be done by query/  For instance, building queries so they are feeding off other queries?
0
 
PatHartmanCommented:
You can create the three separate crosstabs and then a fourth query that joins the three crosstabs.  That will get all the columns on the same line but that isn't what the example shows.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tomfarrarAuthor Commented:
Was trying to get there without creating an Access report.  So let me think about it.  Thanks.
0
 
PatHartmanCommented:
If you don't want to create a report which requires no code, then you can export the three crosstabs to specific places on the same worksheet which does require code.  Or you can create spreadsheet links to the queries and that will refresh them when the Excel template opens.  We need a better idea of what you need.
0
 
tomfarrarAuthor Commented:
Thanks.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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