Two diff reports

[jln via AccessMonster.com]

Ok i have 2 reports that are related. I need to take the total per page that
i have set up on my main report and put it in to my other report.

The first report has 12 rows per page with a page footer that total the
amount of the 12 rows.

I need to have the 2nd report print once per page of the first, and have the
calculated total from the first placed in text boxes. That are setup.

Is there any way of doing this?

I have tryed to do the 2nd report as a sub report and that did not work out
the way that i need. It would not place the 2nd report after each page just
at the end. I know that was because of it being in the report footer.