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