My Assistant
Site Message (Message will auto close in 2 seconds)
Custom Search
|
  |
 Transposing Or Tabulating Access Report Summary Into Excel, Office 2007 |
 Dec 12 2017, 01:00 PM Post#1 | |
 Posts: 311 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) 
Report_Footer.PNG ( 9.01K )Number of downloads: 2
Matrix_Example.PNG ( 11.76K )Number of downloads: 3 |
 |  |
| Dec 12 2017, 01:05 PM Post#2 | |
 Access Wiki and Forums Moderator Posts: 71,923 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 |
| |
| Dec 12 2017, 01:07 PM Post#3 | |
Access Wiki and Forums Moderator Posts: 71,923 Joined: 19-June 07 From: SunnySandyEggo | -------------------- 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 |
| |
| Dec 12 2017, 02:18 PM Post#4 | |
Posts: 311 Joined: 27-June 08 | Thanks DBGuy. I will take a look Regards; Mike |
| |
|
Custom Search
|
 | Search Top Lo-Fi | 23rd April 2018 - 10:11 AM |