I've a access report with page size A3 14 fields and last 6 columns are date columns. When i see the report view then it looks right order. When i try to export the report into excel it returns date columns first and followed by other columns. I use the below code to export report to excel.
Without being able to see an example of your query that the report is based on, and the design of the report, my first guess is that perhaps your query does not return the data in the same order that you have the fields laid out in the report. Off the top of my head, I am not sure just how Access processes a report to do an export of it to Excel so this may be totally wrong but without more information, I would try looking at that as a potential answer.