Hi all,
So I'm not very good at this but here is my problem. I have a report bound to a query of 2 tables. It displays all the data in the detail section as it should. The data comes from the many side of the relationship of the 2 tables. My Report header and page header work fine also. I have a sub report bound to a different query in the report footer that displays the correct data at the end of the report. What I want is for that sub report to display at the end of the data in the detail section only once whether there is only 1 page or 2 pages of data, then I want to display more pages of other stuff that I will add to my report. In other words, I want the sub report data to show only once no matter how many pages there are, but I want to be able to put more pages on the report after it. If there is 1 page of data in the detail, it will show at the bottom of the first page (or right at the end of the data), and if there are 2 pages of data, I want it to show at the bottom of the second page only. Then still have more pages after that.
I hope that made sense. Is this possible?
Thank you!