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,287
Thanks: 0
Thanked 721 Times in 706 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,595
Thanks: 2
Thanked 2,037 Times in 1,993 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 online now   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 50 12-14-2018 10:20 AM
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 09:30 PM.


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

Featured Forum post


Sponsored Links


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