Exporting Reports

[edmundo]

Hi,

I have a report in MS Access (a very simple column,row report) which on a monthly basis I export to Excel. All is fine.

I now need to add a new field to the MS Access report. I add the field, say in column position 10, and now export the report. The field that I have just added in MS Access is now in column A of the exported excel document, not column J where I want it to be. Is there any way I can define where the new column gets positioned in the Excel document? Or do I have to recreate the report from scratch which I really don't want to do...



cheers

Ed

 

[grnzbra]

Try playing with the location of the new field in the query or table that is driving the report.