Fields order changes on sending to excel

[captgnvr]

Dear All



access97.
Have four fields (name; rank; born; join date) in report from a query. All results from the query good.

From report preview, office links are clicked and 'analyze with excel' is clicked. Excel file is generated and file name message props up.

When open the said excel file, the 'name' column is the last one and the first column is 'rank'.

Can you pls tell me what could be the reason and how to get the same order as it is in report?? I have put in the right order in query and report also.

Watching for your response, so that I can sit tonight and finish the programming of crew info data.-
brgds/captgnvr

[SoftwareMatters]

Hi,
I don't know why this happens but you could try running the "analyze with Excel" office link straight from the query. I think this should get the desired result.
Regards
JD