Access Report to Excel tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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,
 
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.
 
Back
Top