I have Access 2003. I am trying to export an 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 to Excel, 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 am putting the subtotals in the page footers.
I’m assuming the only way to get subtotals is to put the information in the footer section.
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.
I’m assuming the only way to get subtotals is to put the information in the footer section.
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.