access 2007,
I've created a macro and I am using the following two action's: OpenReport and then OutputTo. This will output my report as an excel file to a folder. This all works okay. The problem is that within my report I have in the report footer 2 unbound text boxes which I am using for column totals. This appears in my report fine, but when I look at the excel file they are missing. The totals do not come over in the export.
I am thinking I would need to do this another way?
Any ideas?
Bruce D.