bman101010
Technical User
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
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