Hello,
Long time reader, first time poster!
I’m building a report in Access and it is comprised of 2 subreports (each report pulls data from separate queries). I want to build an “Item Count” associated with each row of data. I added a text box in each subreport and set the control source to =1 and running sum "over all". This provides an item count for each subreport but I would like the 2nd subreport to continue from the first subreport last count. Everything I’ve tried so far brings up a #Name? or #Error? message in the 2nd subreport. I even tried to add a hidden counter in the first subreport footer and link to that but couldn’t figure out how to do so.
Where am I going wrong? Thanks in advance for any pointers/solutions to my problem.