How can I start report pg. # based on another report’s pg. count?

Hello,

I am trying to start the page number of a report based on the page count of a separate report in Access 2007. I’ve added a text box in report design in my page header section, and I input =Reports!OtherReportName.Pages+1 and it auto-corrects it to =[Reports]![OtherReportName].[Pages]+1, but gives an error when I try to view the report. What am I doing wrong? How do I reference this correctly in Access 2007? All help greatly appreciated!

submitted by /u/Idunnoitsforwork
[link] [comments]

Posted on