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

Export BPMN Visio Chart to Excel 0
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Setting column width in a table with a macro is not working 0
Column order disrupted on export to Excel 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
how to export the value of checkbox on a report in to excel 2

Top