Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print detail records in footer for each page

Status
Not open for further replies.

bman101010

Technical User
Jan 2, 2003
4
US
Please help. I'm using Access XP and have a report consisting of the following sections:

PAGE HEADER
PT_ID HEADER (This is my group by key)
DETAIL
PT_ID FOOTER
PAGE FOOTER

In the detail section I have a subreport that will print records for each PT_ID. My problem is for each page in the report; I need the corresponding detail records to also print in the footer. Any idea's?

Also, I've tried putting the "detail" subreport in the footer and it works, but it will display the whole detail (or until the page ends) on the first page. My pre-printed form is setup for a max of 9 detail records per page, is there a way to get those same 9 detail records to print in the page footer as well?

I was able to accomplish this using Crystal Reports with an Array, but can't seem to figure it out in Access.

Thanks in advance..

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top