Breakdown reports

B

Brenda Rueter

A user wants to know if there is a way to break down an Access report into
pages and email the separate pages to different people. The question asks
about using Adobe to do this, but I think any viable method would work
including using Word or Excel. Anyone have any ideas for us on this? TIA!
 
F

FinRazel

Here is an answer I wrote for a related question in one of the discussion
groups. I hope it helps.

Subject: RE: create a report for each entry in Access DB? 9/20/2005 1:49
PM PST

By: FinRazel In: microsoft.public.access.reports


Assuming that (using the Report object design view or wizard) you have
already created a single report that is formatted the way you want it (but
contains all of your records, instead of just one)...

Open your report in Design View.

Double Click on whatever section contains all of the data you want repeated
(for me, it is the Details bar, because I don't subsection my data).

In the 'Format' tab, the first setting is "Force New Page," which defaults
to "none," set this to "After Section"

Save

Export this Report as files of type HTML. This will create a separate HTML
file for each of your records (and they link to each other as well!)
 
Top