Columns are not in the same order after export to excel

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
 
J

Jeff Boyce

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
 
I

Irina

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
 
E

Evi

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
 
I

Irina

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
 
E

Evi

It doesn't answer the problem but you can just copy and paste a query into
Excel or Word.
Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to export the value of checkbox on a report in to excel 2
Exporting Report to Excel 2
Will not export to rtf format now, it used to 1
Export to RTF With Chinese Characters 2
Printing report in the same order as entered on a form 2
Why are my Access reports truncated when exported to Word 2003? 1
export report to Excel results in 2 rows of column headers 3
Export data from a Report to Excel? 1

Top