access,
I have a report that contains column totals. I have a macro setup to export this to excel. I realize the totals will not be exported because of the way I am using the unbound text boxes to calcuate them in the report footer.
The strange thing is that when I manually total up the fields in excel they do not match my report totals. I have visually compared the report to the excel file and every record has been exported. This seems impossible!!!
Any ideas?
Thanks,
Bruce D.