One option is to create a section for each of the 12 pages, all based on the
same data.
1. Open your report in design view.
2. Open the Sorting And Grouping dialog (View menu).
3. Select your primary key field, and in the lower pane of the dialog, set
Yes for both the Group Header and Group Footer sections. Access adds 2 more
sections to the report.
4. On the next row of the Sorting'n'Grouping dialog, choose the primary key
field again, and again set Yes for the Group Header and Footer. You now have
2 more sections.
5. Repeat 4 more times.
You now have 6 group headers, 6 group footers, and the detail section, for a
total of 13 sections. Since the sections are based on the primary key, they
occur for every record, so you can lay out the 12 pages of your report, one
section each, and have one to spare.
If you prefer, you can probably fit 2 pages to each section, but the
separate sections just makes it easy to see where the page breaks are.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"ka******@comcast.net via AccessMonster.com" <u15580@uwe> wrote in message
news:5a7d900c82dce@uwe...
hey... i have a quarterly report that i'm working on where each of the 12
or
so pages is completely different from the other. all are based on
basically
the same info (ergo, the same query) but the layout of the controls are
wildly different from each other. right now, i've created each page of
this
report as its own report, just to get me started somewhere. what's the
best
way to open these 12 reports so that they all show up at the same time and
can be easily viewed/printed without having to do them one at a time?
thanks.
