Some of the sum totals are exporting to Excel

G

gdev01

Hi,

I have these totals in the report:
=Sum([custcnt])

=Sum(Val([wgt]))

=Format$(Sum([glamt]),"$#,##0.00")

only sum([custcnt] is appearing on the Excel export. I am using Access 97
and
using DoCmd.OutputTo acOutputReport, r2xls, acFormatXLS to export.

Does anyone know why the other totals won't export over? Is there a work
around?

Please assist.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report to Excel, Error message "Compile Error: Argument not 0
Export to Exel using Access 2000 and 2007 1
Export to Excel 0
Exporting filtered data to Excel 3
export totals from access to excel without moving columns 0
Output report to Excel doesn't include some totals 0
Formatting when exporting to excel 0
Export report to excel ERROR - please help 3

Top