G
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.
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.