Automation

[mbynoe via AccessMonster.com]

Is it possible to have the totals in a report to automatically populate into
an Excel cell? I have a report that has 2 totals that I need to auto-
populate into an excel form.

Thanks!

 

[Andy6]

*****************
Normally totals on a report are created in dummy text boxes in the footer of
the report and sum the value fields above for showing or printing.
The data on the report comes from an inbuilt query behind the report and
therefore has field names that can be exported to Excel, but the dummy text
boxes cannot.
So create the totals fields within the query and export them from there to
the relevent Excel cells.
Good Luck....A.
*****************

 

[mbynoe via AccessMonster.com]

Thanks!

*****************
Normally totals on a report are created in dummy text boxes in the footer of
the report and sum the value fields above for showing or printing.
The data on the report comes from an inbuilt query behind the report and
therefore has field names that can be exported to Excel, but the dummy text
boxes cannot.
So create the totals fields within the query and export them from there to
the relevent Excel cells.
Good Luck....A.
*****************