Page Footer sum Microsoft solution question

I don't think I can successfully have it in the detail because it's going to
either repeat the subreport over and over. Or it will print 1 record from
the main report then the subreport then the 2nd record of main and so on.

Is there anyway to just make the report treat the 2nd page of the main
records and the subreport as a 2nd report somehow with the extra records?
"Marshall Barton" wrote in message
news
You'll have to refresh my memory as I deal with too many
threads every day to remember the details of any one,
especially after more than a week.

From what I do remember of your 28 lines per page question,
the page footer was never part of the question.

There may be several things getting in your way when using
the page footer. Most important in your case is that you
can not start a new page in a page header/footer section,
regardless of whether you are using a subreport or not. If
you want the subreport to span multiple pages, you will have
to move it out of the page footer section.
--
Marsh
MVP [MS Access]


Michael wrote:
The new changes definitely are not the problem. This was happening before
that as well. Just thought you might know something about it since you
seem
well versed in Access.

The subreport has the page break code, you gave me a few days ago, and it
works by itself but for some reason it seems that the main report ignores
that code when the subreport is in the page footer instead of the report
footer.

"Marshall Barton" wrote
Michael wrote:

The only problem now is the subreport's first 28 records, even though it
skips to 29th record on 2nd page in subreport by itself, simply repeats
that
first 28 records on page 2.


I can't see how the page total changes can have anything to
do with this new problem. Check other places, especially
the links between the main report records and the subreport.

Of course the detail will not work. Maybe you can use a
group footer or through some tricky maneuvers, maybe some
other way. BUT I REALLY NEED TO KNOW what effect you are
trying to achieve here.

It almost sounds like you want something as bizarre as two
reports, one using the top half of the page and the other
using the bottom half.
--
Marsh
MVP [MS Access]


Michael wrote:
I don't think I can successfully have it in the detail because it's going to
either repeat the subreport over and over. Or it will print 1 record from
the main report then the subreport then the 2nd record of main and so on.

Is there anyway to just make the report treat the 2nd page of the main
records and the subreport as a 2nd report somehow with the extra records?

"Marshall Barton" wrote
You'll have to refresh my memory as I deal with too many
threads every day to remember the details of any one,
especially after more than a week.

From what I do remember of your 28 lines per page question,
the page footer was never part of the question.

There may be several things getting in your way when using
the page footer. Most important in your case is that you
can not start a new page in a page header/footer section,
regardless of whether you are using a subreport or not. If
you want the subreport to span multiple pages, you will have
to move it out of the page footer section.


Michael wrote:
The new changes definitely are not the problem. This was happening before
that as well. Just thought you might know something about it since you
seem
well versed in Access.

The subreport has the page break code, you gave me a few days ago, and it
works by itself but for some reason it seems that the main report ignores
that code when the subreport is in the page footer instead of the report
footer.

"Marshall Barton" wrote
Michael wrote:

The only problem now is the subreport's first 28 records, even though it
skips to 29th record on 2nd page in subreport by itself, simply repeats
that
first 28 records on page 2.


I can't see how the page total changes can have anything to
do with this new problem. Check other places, especially
the links between the main report records and the subreport.