View Single Post
  #9  
Old June 7th, 2010, 07:06 PM posted to microsoft.public.access.reports
VBNovice10
external usenet poster
 
Posts: 7
Default Force the group footer to print on the first page

Thank you for your quick response. As far as faking it, here are some
details of my report. My current group footer contains 4 signature blocks
tracking items exchanged from one person to another person. There are five
columns (Item#, Date, Released By, Received By, and Purpose, respectively).
The 4 rows track four different exchanges between individuals. The
information in this section is provided post printing and the framework is
needed only on the bottom of the first page. There is no computing or
calculations required to be filled into this section prior to printing.

Please let me know if you need further information or if my description is
unclear.

Thank you.

"Marshall Barton" wrote:

VBNovice10 wrote:

My report is based off of a current form we manually create through Microsoft
Word for every customer. Each customer may have anywhere from 1 to 300
items, so the detail section length varies. But I want to populate the
report through Access from my database to expedite the former form creation.

My report has a report header with a logo, a page header with recurring data
on each page, a detail section with rows of data populated by rows in my
database, a group footer, a page footer with page numbers, and a report
footer which takes up the entire last page.

I was hoping there was a code/method to force the group footer to always
print on the "first page" only regardless of the number of rows in the detail
section. The main question is can a group footer be forced to print in the
middle of a group section?


No. If the group footer displays some kinds of totals for
the group, those totals may not have been calculated until
the last detail has been processed. In that case it would
not make sense to try to print that kind of total the way
you want.

In some situations, a report can be made to use the page
footer to display something different (not running sum
totals) on specific pages, but this can get kind of
messy/tricky. If there is some way to fake what you want,
we would have to know a whole bunch of details about what
you need to display in this simulated "group footer".

--
Marsh
MVP [MS Access]
.