M
melweach
I am trying to export totals from my Access report to Excel. I created the
a formula total in a group header using a text box. However, when I export
it the totals are no where to be found. What could I be missing? It seems
like I should be able to do it based on the help menu(as follows):
If you output the data in a report, the only controls that are included in
the output file are text boxes (for .xls output files), or text boxes and
labels (for .rtf, .txt, and .html output files). All other controls are
ignored. Header and footer information is also not included in the output
file. The only exception to this is that when you output the data in a report
to a Microsoft Excel file, a text box in a group footer containing an
expression with the Sum function is included in the output file. No other
control in a header or footer (and no aggregate function other than the Sum
function) is included in the output file.
Thanks for the help!
a formula total in a group header using a text box. However, when I export
it the totals are no where to be found. What could I be missing? It seems
like I should be able to do it based on the help menu(as follows):
If you output the data in a report, the only controls that are included in
the output file are text boxes (for .xls output files), or text boxes and
labels (for .rtf, .txt, and .html output files). All other controls are
ignored. Header and footer information is also not included in the output
file. The only exception to this is that when you output the data in a report
to a Microsoft Excel file, a text box in a group footer containing an
expression with the Sum function is included in the output file. No other
control in a header or footer (and no aggregate function other than the Sum
function) is included in the output file.
Thanks for the help!