New Page (revisited)

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Well I got the new page down that I was asking about previously, however I
have something new.

Again I need the sections of the report to print on separate pages, because
they will be used as reports mailed to different people.

I have a query that lists FirmName(duplicates are possible), FirmNumber(this
is a primary key, no dups), MasterFirmNo (this will have duplicates, all the
same FirmName have the same MasterFirmNo), MemberID (this is a primary key
no dups), FirmNo(no dups) And other fields that should not be a concern for
what I need.

Report:
Header:
MasterFirmNo (not shown on actual report)
FirmName

Detail:
I have all the information I need the report to show for each Firm which
includes a field DuesAmount

Page Footer:
I need it to sum up the DuesAmount for each MasterFirmNo, which I have
=sum(DuesAmount), this is not working.

What I need on each page of the report is to list the MasterFirmNo with all
of the MemberID and DuesAmounts and then total that MasterFirmNo DuesAmount
at the bottom of each page.

Any help would be greatly appreciated!!

Thanks in advance.
Rebecca S.
Access 2002 (sp3)
 
I am not sure what you mean with "I need the sections of
the report to print on separate pages". What sections are
you referring to here.
You than go on to list the "Report Header", the "Detail"
and the "Page Footer".
Each one of these is as described and can not be separated
to a separate page.
Please come back with some more detailed information.
Fons
 
I'm sorry..
What I meant is I need each MasterFirmNo to have it's own report. To have it
have a page break after each MasterFirmNo. So that the next MasterFirmNo
will print on it's own page (s).

I have been trying what you wrote in response to my last New Page question,
but am having no luck.

Rebecca S.
 
Okay Rebecca, I think I see.
First, in report design view, open the grouping sorting,
If you have not, create a group for MasterFirmNo. In the
same window set the group header and group footer to yes.
Now close the sorting/grouping window.
In the report design view, select/remove the fields you
have in the report header (Ctl X) and copy them in the
Group header band.
And while you are in the group header band set the group
header band property for force new page to before section.
Now move the fields from the report footer to the group
footer band.
I think this will mostly do all you described, you may
have to make some adjustments.
Good Luck.
Hope this helps.
Fons
 
Fons, thank you for being so promp. I am going to try this.. first, what
exactly is the group header band.

Rebecca
 
I played with it.. and yippee.. it worked..
Thank you for your step by step instructions.

Thanks again!
Rebecca
 
Rebecca, when you design a report and initiate grouping
(through the sorting/grouping window) you have the option
of selecting a header and/or footer for each group you
create. When you set the header/footer to yes, an extra
band becomes visible in the report design window, than you
can use these band(s) to enter the header for this group
and the footer for this group (like a summary block)
Hope this clearifies it for you.
Fons
 
Back
Top