Extra column in Excel

G

Guest

I am exporting an Access report to an Excel format. I notice that the
report's footers (which I am placing my subtotals) are placed one column over
when exported into Excel. Any idea of why footers are not lined up with the
rest of the data when exported to Excel? They appeared to be lined up
exactly in the Access design view of the report.
 
J

Joe Fallon

Export of Reports is always a hit or miss affair. (The problem you describe
is just one of the issues.)
I almost never do it.
I usually write a query and export that instead.
 

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

Exporting to Excel looses Report subtotals (footers) 1
Export Access Report to Excel keep format 4
Access Export of data to Excel using VBA - data looks awful 4
exporting to Excel 3
Export to an already setup excel spreadsheet where columns<> 9
Exporting ACCESS Report to Excel format 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export or Import to Excel and Format 4

Top