UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Crosstab With Multi Columns, Access 2007    
 
   
foxtrojan
post Aug 31 2019, 10:25 AM
Post#1



Posts: 1,158
Joined: 8-May 06
From: Singapore


How do you do a Cross-tab with multi-columns, like

Row Total Qty Total Amount Jan Feb Mar
Apples 10 $10.00 5 $5.00 3 $3.00 2 $2.00
Oranges 20 $20.00 10 $10.00 5 $5.00 5 $5.00
Go to the top of the page
 
GroverParkGeorge
post Aug 31 2019, 11:53 AM
Post#2


UA Admin
Posts: 35,847
Joined: 20-June 02
From: Newcastle, WA


See the enclosed sample.
Attached File  FruitSold.zip ( 22.75K )Number of downloads: 14

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
foxtrojan
post Aug 31 2019, 12:43 PM
Post#3



Posts: 1,158
Joined: 8-May 06
From: Singapore


Thank you so much for your quick response. So sorry the program is in 2003 version. Appreciate if you can give me your demo in Access 2003.
Go to the top of the page
 
RJD
post Aug 31 2019, 05:53 PM
Post#4


UtterAccess VIP
Posts: 10,081
Joined: 25-October 10
From: Gulf South USA


Hi: PMFJI, but I see you haven't gotten the A2003 version yet (looks like George is busy). So I thought I'd do that ...

HTH
Joe


Attached File(s)
Attached File  FruitSold_A2003.zip ( 18.96K )Number of downloads: 12
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
foxtrojan
post Sep 4 2019, 02:28 PM
Post#5



Posts: 1,158
Joined: 8-May 06
From: Singapore


Thank you so much Joe. Yes, still using the 2003, but in the midst of migrating to Version 2019.
Go to the top of the page
 
RJD
post Sep 4 2019, 03:35 PM
Post#6


UtterAccess VIP
Posts: 10,081
Joined: 25-October 10
From: Gulf South USA


thumbup.gif

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
foxtrojan
post Sep 8 2019, 10:41 AM
Post#7



Posts: 1,158
Joined: 8-May 06
From: Singapore


Thanks you so much, the multi columns cross tab works perfectly. With that I can create standard Statistical Cross Tabs for those guys who do not know how to do pivoting in Excel.
Thanks again.
Go to the top of the page
 
MadPiet
post Sep 8 2019, 09:22 PM
Post#8



Posts: 3,330
Joined: 27-February 09



Can't they use Pivot Tables?
Go to the top of the page
 
foxtrojan
post Sep 20 2019, 08:36 PM
Post#9



Posts: 1,158
Joined: 8-May 06
From: Singapore


Hi MadPiet, that's interesting. How you go about it? Appreciate very much if you have a working sample for me to follow.
Go to the top of the page
 
MadPiet
post Sep 20 2019, 10:05 PM
Post#10



Posts: 3,330
Joined: 27-February 09



Fox,
If you're using 2007, I'm not totally sure. I haven't used it in forever.
Later versions of Excel will let you do pivots until you're blue in the face, but they're more suited for analyzing data than just cranking out a standard static crosstab. So it depends what your needs are. The catch is that PowerPivot (2010 and later) uses DAX. You can avoid it for simple stuff, but if you learn some of it, you can do some seriously awesome analyses.
If that's what you're after, check out chandoo's channel on YouTube. (he has a great intro lecture that's maybe 10 mins long). If you can get your hands on a copy of a newer version of Excel, check out Rob Collie's website, www.powerpivotpro.com - if you look at the Book stuff, there's a place to download the files. You can poke around in them and see what you can do. But that's if you need more analysis and less just reports.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th October 2019 - 02:05 AM