Desperate to get issue resolved. Please help.

[dbl]

Hi when I send reports to Excel all the field headings go back to the field
names in the qry/table even though I have change them in caption, plus they
also go back to the table lay out order.

How do you stop the headings and field order on the report being changed
when the report is exported to Excel?

Sorry to have posted this twice but I am desperate for some help with this.

Thanks Bob

 

[Ken Snell \(MVP\)]

Column headings that are put into the EXCEL worksheet are the names of the
fields from the report's RecordSource. Assuming that you're using a query
for the report, you'll need to use aliases for the fields. Captions are not
read by the export process.

If you're not using a query for the RecordSource, then create a query and
use it instead of the table.

To make an alias for a field:
in design view: MyNewName: TheOldName
in SQL: SELECT TheOldName AS MyNewName, ...

 

[dbl]

Thanks for your help Ken, it now works fine.

Regards Bob