Columns are not in the same order after export to excel

  • Thread starter Thread starter Irina
  • Start date Start date
I

Irina

I have a question about reports in access.
I created a simple report in access that looks great in word (exported as
snp or rtf)
but when I export the same report into excel - the columns are not in the
same order. They are all shuffled.
Is there a control in the report that would set the order?
does someone know if this is possible?
thank you
 
Irina

It may be that your report is based on a table or query that has the fields
in one order, but the report displays them in another.

Is there a chance the order displayed in Excel matches the order of the
underlying table or query?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff, the table that the report is based on has a lot of fields that the report
is not using. The report looks great when in print preview, exported as word
or rtf, but as soon as I export as excel 2003 format (that is what the
format of
db is access 2003) the order of the fields is not the same. Some fields
that are at the end of the report, appear in the middle and so forth.
Other access developer advised me that she experienced the same issue but
has not found the resolution.
Do you have any other ideas on this? Some of the users would like the report
in excel.
thanks,
Irina
 
Instead of basing your report directly on a table, in Report Design View,
click on the Properties Button, click just right of the Record source to
evoke the Query builder. Add to this only the fields which are in the report
and add them in the order in which they appear in the report. See if this
makes a difference to the Excel Export.
Evi
 
Evi-I have created a query as you suggested, and the order of fields in the
query
is what the users want. When I export the report as rtf or preview the report
the order is what the query shows, looks great, and again when I export as
xls - I still get all the fields but they are not in order.
I dont get why excel changes the order of fields. This seems strange.
I am not sure what else I can try.
Anyone please advise.
thanks
 
It doesn't answer the problem but you can just copy and paste a query into
Excel or Word.
Evi
 
Back
Top