Show total Count of rows in query on each page

[VicM]

Hi,
Using Access 2010 on a Win 11 Pro box.
I'd like to show the total number of items in the query I'm using as the Record Source on each page. When I use the Count function in a calculated control in the Page Footer, I get an error. But if I put that same control in the Report Footer, I get the number of items in the query.

As a bit of background: when I generate the report I then save it as a PDF so I can send it to my phone. One of the reports I generate has only one page of info. But the other has about 13 pages and can grow over time. So I'd like to see how many records are in the report without necessarily having to scroll down to the last page of that PDF.



Any thoughts?

Thanks,
Vic

[June7]

Textbox in page footer has expression that references textbox in report footer: =tbxTotal

Might want some code that will hide page footer textbox on last page. I'm not sure what that would be.

[Micron]

I might put it at the top if the only important thing in a phone view was the record count.

[VicM]

June7
Great suggestion!!
I put a text box in the Report Footer, put the =Count(*) in its Control Source, set its height to 0", reduced the size of the Report Footer to nothing. Then put a text box in the Page Footer and referenced the text box in the Report Footer.
Works like a charm.
Thanks again.

[June7]

Micron has a good point. Unless you want to see this count on every page, could just have Sum() in report header.

[VicM]

June7,
Yes. I do want to be able to see the total count on each page. As I said above, your suggestion allowed me to get the result I wanted.
Thanks again,
Vic

[June7]

Along same line, placing in page header might reduce scrolling.
Great idea on setting textbox and report footer heights to 0.
Could set the report footer textbox not visible. That alone will not allow report footer to be 0 height but would allow other stuff to be displayed in footer if that need arises.

[Welshgasman]

June7
Great suggestion!!
I put a text box in the Report Footer, put the =Count(*) in its Control Source, set its height to 0", reduced the size of the Report Footer to nothing. Then put a text box in the Page Footer and referenced the text box in the Report Footer.
Works like a charm.
Thanks again.

When I do that I get the same value as the report footer on each page?

[June7]

That's exactly what OP wants. "I'd like to see how many records are in the report without necessarily having to scroll down to the last page of that PDF"

[Welshgasman]

That's exactly what OP wants. "I'd like to see how many records are in the report without necessarily having to scroll down to the last page of that PDF"

Ah, misunderstood. I thought it was like a running count, so 20 on first page, 52 on second etc.

In that case I would have gone with Micron's suggestion, saves even scrolling down to the bottom of the first page on a phone.

[June7]

I know how to do a count on each page but a running count is a new challenge.