Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-08-2018, 05:03 PM   #1
Brand2K
Newly Registered User
 
Join Date: Nov 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Brand2K is on a distinguished road
Crosstab Expert, multiple values under a single column header.

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

Brand2K is offline   Reply With Quote
Old 11-08-2018, 07:08 PM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,139
Thanks: 0
Thanked 683 Times in 668 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Crosstab Expert, multiple values under a single column header.

no images show
Ranman256 is offline   Reply With Quote
Old 11-08-2018, 07:35 PM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,434
Thanks: 2
Thanked 1,993 Times in 1,949 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Crosstab Expert, multiple values under a single column header.

To post a picture (or database) before 10 post zip it.

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 11-09-2018, 12:26 AM   #4
Brand2K
Newly Registered User
 
Join Date: Nov 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Brand2K is on a distinguished road
Re: Crosstab Expert, multiple values under a single column header.

Sorry about that, rookie mistake. Zip file with 2 images attached.


images.zip


KB

Brand2K is offline   Reply With Quote
Reply

Tags
crosstab , queries , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate Column Values from Multiple Rows into a Single Column erncelen Queries 47 08-20-2014 12:02 PM
Single column Combobox to list values from multiple fields manusri Forms 1 04-08-2013 01:28 PM
Re: Concatenate Column Values from Multiple Rows into a Single Column Snuffy94 Queries 2 07-19-2012 08:54 AM
Get Column and Row header values from crosstab to pass as value waroo General 1 11-15-2011 05:18 PM
Accessing multiple values within single column. Meanmotion General 23 11-03-2004 10:40 AM




All times are GMT -8. The time now is 01:42 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World