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
> Transposing Or Tabulating Access Report Summary Into Excel, Office 2007    
 
   
mmadani
post Dec 12 2017, 01:00 PM
Post#1



Posts: 277
Joined: 27-June 08



Hello Friends;

I have several reports and I summarize the results in the report footer (see attached)

I got a requirement to day to do so also in a tabulated spread sheet

Any quick ideas , instead of making this a manual process? Code and or examples /Ideas would be much appreciated. It does not have to be in Excel. Access will do, I just have to draw or make a matrix t olook like the Attachment. I have to do this for one or more reports.


Thanks

Mike
This post has been edited by mmadani: Dec 12 2017, 01:00 PM
Attached File(s)
Attached File  Report_Footer.PNG ( 9.01K )Number of downloads: 2
Attached File  Matrix_Example.PNG ( 11.76K )Number of downloads: 2
 
Go to the top of the page
 
theDBguy
post Dec 12 2017, 01:05 PM
Post#2


Access Wiki and Forums Moderator
Posts: 71,230
Joined: 19-June 07
From: SunnySandyEggo


Whenever there's a requirement for a specific format for the spreadsheet, I tend to use a template file and use Excel Automation to fill in the cells.

Just my 2 cents...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
theDBguy
post Dec 12 2017, 01:07 PM
Post#3


Access Wiki and Forums Moderator
Posts: 71,230
Joined: 19-June 07
From: SunnySandyEggo


There's a whole section in our Code Archive for Excel Automation.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
mmadani
post Dec 12 2017, 02:18 PM
Post#4



Posts: 277
Joined: 27-June 08



Thanks DBGuy. I will take a look

Regards;

Mike
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 07:48 AM