report footers are not exported 1

[jommyjet]

I have several report footers that are not included in the report when I download it to excel from a macro, and they are also not in excel an outlook attachment. does anyone know why? thanks

 

[CosmoKramer]

It looks like it's a known problem:

Unlike groups in Microsoft Access, Microsoft Excel outlines have only a header or a footer, not both. For this reason, all information in the report's group header is included in the output. Only sums are output from a report's group footer. To include group information in the output, place the information in the group header instead of the group footer.

http://support.microsoft.com/default.aspx?scid=kb;en-us;129467

 

[jommyjet]

thanks cosmo, the header method works, but when you have a group header summary and report header summary it looks silly. the article mentions sums in group and report footers will be included in the download. It says further that if you have more than one sum per field (which I do, group and report)that the sums are placed in a column next to the field. neither sum is included. any ideas? thanks again