Question Crosstab Expert, multiple values under a single column header. (1 Viewer)

Brand2K

New member
Local time
Today, 15:33
Joined
Nov 9, 2018
Messages
2
Hello,


I have only recently started using Access again, my previous experience ended when Access 2000 was brand spanking new, so it has been a while.


I am trying to wrap my head around the limitations of cross tab reports here.



Since a picture is worth more than a few lines of text, below is what I am trying to achieve.





In other words, I am looking to show multiple values/totals under a single column header. The above took about 30 seconds in Crystal Reports using the cross tab expert.





Is there any way in Access to simulate the above report, or am I barking up the wrong tree? Have I missed something obvious?



Any advice would be greatly appreciated!



KB
 

JHB

Have been here a while
Local time
Today, 16:33
Joined
Jun 17, 2012
Messages
7,732
To post a picture (or database) before 10 post zip it.
 

Users who are viewing this thread

Top Bottom