• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

output Group sum to excel

I am not able to see the group sum when i analyse it with Excel. Though it is written in the OUTPUT function help that the sum in group footer is visible in ms Excel i am not able view that. Please help its urgent
0
pradeep_no1
Asked:
pradeep_no1
  • 3
  • 2
1 Solution
 
Zmey2Commented:
Will you please explain details?
What kind of sum you are unable to see? What is OUTPUT function? I can't find such function in MS Excel.
0
 
pradeep_no1Author Commented:
In ms access Reports we group the report and we have groupwise sum. And we also have the ANALYSE WITH EXCEL Button which is same as OUTPUT Function in MS access , which transfers your Report to Excel. But My problem is that i get all the records but i Do not get the sum which is mormally in the group footer in Excel, which is my Problem. I hope u got it. If not please say.

0
 
Zmey2Commented:
You might mean DoCmd.OUTPUTTo
Unfortunately when you throw report to excel you sending only data, not format.
So you need compute your sum after sending data to excel.
That may help you:
http://www.zmey.1977.ru/Access_To_Excel.htm
http://www.zmey.1977.ru/Excel_And_Autofilter.htm
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
pradeep_no1Author Commented:
Zmey2 Thanks for your Response. But if you see the HELP for OUTPUTTO function you will see it clearly states that if you have SUM function in the group footer then it will show up in excel. And that is what i want. I don't want to type huge lines of code for transferring from Access to Excel.
0
 
Zmey2Commented:
>And that is what i want. I don't want to type huge lines of code for transferring from Access to Excel.
If you succeed, please teach me, how to avoid it :)
0
 
walterecookCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: Zmey2 {http:#8109662}

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now