exporting report fields to spreadsheet

[Gordon Freeman]

I have some Access 2003 reports that print fine, but if I save them as an
Excel spreadsheet (from the print preview) I find that some recently added
summary fields don't appear in the resulting spreadsheet, yet others do.

In some cases I can see it might be because they contain formulae that
Access may not know how to convert into excel formulae, but others have
straightforward contents like =Count(*) or a simple value, so I'm wondering
if there is a setting or format value somewhere I need to set to get them
to export. Also I notice that of fields that do export, some retain their
Access format in excel and some don't, e.g. dates in report headers
displaying as integers.

 

[Arvin Meyer]

No. The best way to be sure that everything is properly exported is to build
a table from the report's query and export that.

Actually, a Date field is a special Double datatype. In fact early versions
of Access used a Double in code.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://access.mvps.org
Co-author: "Access Solutions", published by Wiley