Automation

  • Thread starter Thread starter mbynoe via AccessMonster.com
  • Start date Start date
M

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!
 
*****************
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.
*****************
 
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.
*****************
Click to expand...
 
Back
Top