Access Report to Excel tabs

[Steve Voorhees]

I have a report that is created in Access. Is there are way to have the
report, with my formulas, export to Excel with each page in the report
appearing in a separate worksheet?

 

[George Nicholson]

With formulas? No, not unless your formulas appear on the report as
formulas. WYSIWYG, data-wise.

Even then, I'm not sure about the "one report page = one worksheet"
requirement. Exporting to Word tends to maintain report pagination, but
exporting to Excel from a report acts more like a data dump (assuming the
report format supports exporting...).

HTH,

 

[Steve Voorhees]

Thank you. I figured that that was the case. The person that I have been
working on the database for had asked me, and I told her that it likely was
not possibly, but that I would check.
Thank you once again.