Export ACCESS Report to EXCEL

S

sun

Would like to export an ACCESS report to an EXCEL file.

A table as follows:

CUSTOMER REVENUE
======= =======
CHANSON 100.512

An ACCESS report is created based on the table. I have change the decimal
format of the REVENUE data field in the report to 1. The display of value
would be 100.5

However when doing an export to EXCEL as below a full numeric value 100.512
iso 100.51 is shown.

Could any expert help? Thanks in advance!


Code to export to an excel file as follows:
DoCmd.OutputTo acOutputReport, strInputReport, "Microsoft Excel", REPORTPATH
& strFileName.
 
Top