Access Report Totals are Missing when exporting report to excel

[gdev]

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 beside using Excel code in Access?

Please assist.

Thanks

 

[dhookom]

I would use the Val() in the report's record source query. Also, consider formatting a control in the Format property rather than using the Format() function in the Control Source.

Duane
Hook'D on Access
MS Access MVP