Question Crosstab Expert, multiple values under a single column header.

Brand2K

New member
Local time
Today, 19:37
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.


rOd1v_3XkrmOpXqkzZECislEsOMoJ5zp9B_fMHZy4QArdFbIEvIMLfSHNIJlRSESQ6uMcg7rpAzLVPLS7yrPDSYz50hFLuYLKaeSssPyFSpPMUWXVL0rt4Gkgb24_hZM1D_9mVop-L7EL-epjdX_mVbBuZPgP2rKW-WLAPsDQdyK_AiG2GuSvuqMgmuRstbaTeaSCaIjtQNWQ6cDtIc4f989WvOqT0QdHU5sC6iFXT2B65clQYhjFMbnadkFr6WANi_lN4YGfd1VjG3c_yRCiEMduLCj0pr1OE65utFuD6oN2-Gf1Hb8Qps9oiKjwBrccFIr3n6M0m3FVjpQW_Yllmp7Q3ZGZ3_KqAOLmohYeB4kyBXvcbrgL7xFvdsYgTKeq8KjLQC_NGq7zkI_A9fukmPXWdV7AH95I9wix4-2ztYVBF8Vh__CpqV-zUGLDtqfCpr3QVoX8GQsOybiuCRRjpCaYJUUnZxPsR-PMA7D2dSUJfa6gRHmkd1MFLyEDWJdAG6VnzLV1WVz9NWN-mHIqFRlQlyPVszIAnfL2y-x9rQS-kEXeFY6-m_fAV-Jh58uECsml3JWTZyeNVm9uvZ3bl6ezsPfUw9arnkeXKNWob9uTnTSVPGDHYueoJQtIQnVTk_7yFiM8xmhLXQ55yIW8M62EFfpC8cvHh4-P-CHgfXBSA=w895-h152-no



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.



DAHkrpAFmRvtNGGDqV4cOIQG9JP1tz828LOyHWeA_r7edVBEGZ1rFnNuTQivux-HzvflQrk0NQZA-LiX6AIrM_mZCgh12ZKgVWM082U9JzgypBfnV_PLN4jJr9zMP96lCNIyF4NafqZ59dhDSozPPP3qrpJTj4UOyyEPqnKe1g-BIkrjfcdXTXj_YZGt28zz_Bi06ZueF8JVUqPaKtCHpzk9_PlGgTPpI5MHMSWRyD6Ub71WkP1N5x-E8FLvfVRVx6UBAUY8v4pn42LIEhnaN42suNV4MjzvM_6Ur7AL4Kc17aFnP9hGM2leCEK4D6dMnnLtYIbPQ3BM8gXeGnmBh7TNCtPdez1P9f7XHXUnWVRYzI5ItP_2-gVH02N66HiLJvuwWHdaTRKfjnAGBd0Sw9HEEd025WZhYSbnVCBz7GYPP9CPace9bpVInj9pGt9erbmd31x6E28_weRS5uaX3Dh0IPsPHCI9vPgFojpl299wqXMKmQ_W3pfF8WEdPYVZ0CxU9MzVnYsfnNUkycHmuaB49M-EiC9Yrpinjjeq81w3uLoT2vq3fisywgvbRp-3fMyXCK3udryXYkLuElEUBV1Zt9NJovEE6xYrtXZlW0OCLZRATg-59vo14qXQcONha4ItjVCgxvRJr2Zbn1jB424Bf2fpBkPP0Ol5EHFFJkQF7w=w749-h492-no


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
 
To post a picture (or database) before 10 post zip it.
 

Users who are viewing this thread

Back
Top Bottom