Page Breaks

To my knowledge there is no way to make a subreport located in a page footer
to page break to a second page, say after 28 records?

Are there any other alternatives that anyone can think of? It cannot go into
the report footer because I need it to show on each page. It cannot go in
the details section unless you have a way of having the top of the report
show in it's entirety (up to 28 records per page) and then the subreport in
it's entirety (meaning of course the 1st 28 records as the top report).

Just to help everyone understand what I am doing: I have a deposit records
with 1-28 checks per page as my top report. Underneath is a deposit slip
that has rotated text boxes so that it appears to be a rotated subreport. If
I have more than 28 records I want them both to only show 28 records on the
first page and then up 28 records on the 2nd page, etc ....

My only possible solution for this would be to create a column in your record
source queries that group your records into bunches of 28. For instance, the
first 28 records would have a 1 in the column and the next 28 would have a 2,
etc. This would allow you to create a main report record source of the 1, 2,
etc and use Link Master/Child to display the appropriate group of 28 records.
--
Duane Hookom
Microsoft Access MVP


"Michael" wrote:

To my knowledge there is no way to make a subreport located in a page footer
to page break to a second page, say after 28 records?

Are there any other alternatives that anyone can think of? It cannot go into
the report footer because I need it to show on each page. It cannot go in
the details section unless you have a way of having the top of the report
show in it's entirety (up to 28 records per page) and then the subreport in
it's entirety (meaning of course the 1st 28 records as the top report).

Just to help everyone understand what I am doing: I have a deposit records
with 1-28 checks per page as my top report. Underneath is a deposit slip
that has rotated text boxes so that it appears to be a rotated subreport. If
I have more than 28 records I want them both to only show 28 records on the
first page and then up 28 records on the 2nd page, etc ....