Export of Totals to Excel

[Newbee1000]

I generate a report in Access and then email a excel version of the report using the

DoCmd.SendObject acSendReport, "[Report Name]", acFormatXLS, "", , , "test", "Test Message ", 0, False

I have subtotal and grand total on my Access report that give me the correct values when I see the report in Access but when I open the exported version of this report in excel it gives me the sub total and grand totals as same values. How can I pass the total to excel?

 

[assets]

Have you tried the office link button to see if it export to excel.

Never give up never give in.

There are no short cuts to anything worth doing

 

[Newbee1000]

I was trying to do this through a macro that runs every two weeks through a batch file.
I got the totals to export successfully.
Thanks

 

[assets]

which ver. of access?

Never give up never give in.

There are no short cuts to anything worth doing

 

[Newbee1000]

Access 2003