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!