B
BethB
Hello all. I have a report that contains a subreport that I am exporting to
Excel. I am not going to ask how to retain the lines/logos, etc. I am
puzzled, though, because I have the sub-report snugged right up against the
left margin, in perfect alignment with the report, and when I print from
Access, the formatting is great. However, when I export the info to Excel for
analysis, the subreport shows up one row below the end of the report (that's
fine), but it's a column over from the last column used for the report. (i.e.
- the report takes up columns A - E, lines 1 - 250, and the subreport appears
in columns F - J, lines 251 - 275).
Any way to get the subreport to start in column A upon export to Excel?
Excel. I am not going to ask how to retain the lines/logos, etc. I am
puzzled, though, because I have the sub-report snugged right up against the
left margin, in perfect alignment with the report, and when I print from
Access, the formatting is great. However, when I export the info to Excel for
analysis, the subreport shows up one row below the end of the report (that's
fine), but it's a column over from the last column used for the report. (i.e.
- the report takes up columns A - E, lines 1 - 250, and the subreport appears
in columns F - J, lines 251 - 275).
Any way to get the subreport to start in column A upon export to Excel?