Exporting an Access Report to Excel - Sub total column shifts over

[Rhonda from Pomona, NY]

I have Access 2003. I am trying to export a Access report over to Excel. I
have groupings with sub totals within the report. The problem I am having is
that when the file is exported over the sub total column shifts over one
column. Does anyone know how I could get the amount columns with the sub
totals to stay within there own column.

I eventually want to automate the process using VBA with the OUTPUTTO
command. Also I want to use a Excel template so the columns will be
formatted does anyone know who to fix this problem.

THank....

Rhonda

 

[DL]

Suggest you cross post to both an MS Access and MS Excel ng's

 

[Beth Melton]

If your report also contains a calculated total in the Report Footer
then that could cause this issue.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Rhonda from Pomona, NY" <Rhonda from Pomona,
(e-mail address removed)> wrote in message
news:[email protected]...