Analyze with Excel Issue

[Chad Cameron]

Hi All,

When I 'Analyze with Excel' a report, the columns are in a different order
than the report. Is there a way to fix this?

Chad

Ex: A,B,C,D,E comes out B,C,D,E,A

 

[Roger Carlson]

This is just a shot in the dark, but what order are the columns in the
record source of the report?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Chad Cameron]

Sorry for the delay in replying,

I am not sure what you mean by record source. If you mean control source,
each field has it's own name (not textbox1, textbox2) so I am not sure the
order of creation (if that is what you mean). Nor can I find a tab order or
anything like that.

When I recreated the report it seemed to work fine. (Which I am currently
using). It would be nice to fix, incase it happens again on a more indepth
report.

Chad

 

[Roger Carlson]

The Record Source is the table or query which provides the data to the
report. I wondered about the order the fields were presented. As I said, a
shot in the dark.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Chad Cameron]

ok,

No, the data in the source is the same as the report. Excel rearranged it
for some reason. Maybe I re-arranged the columns in the report when I was
creating it, and excel has some hidden ties to the order.

Anyways, recreating the reports seemed to have fixed it.

Thanks,
Chad

 

[Roger Carlson]

The ways of Access/Excel integration are often mysterious. <smile> Sorry I
couldn't be more help.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L