What is the logic on how Report fields are exported to Excel

[wanluo]

Tried to export a report to Excel using Tools>Office Links>Analyze It With Microsoft Excel menu. The order of the fields appearing in Excel doesn't seem to match the order on the Access report layout. What is the logic on how the fields exported? Thanks.

 

[gemma-the-husky]

i think it exports the underlying query, not the report

although you can save the report in this way, its better to get aquery (which looks like a spreasdsheet) set up as you want it, and then use a

transferspreadsheet macro or vba command to save it.