I have a report with one to many subreports. The number can vary. How do I refer to each subreport (or all) when trying to sum a field in each subreport producting a report total.
I have tried to sum from the page break section...but understand Access won't allow and an error is produced.
I have created a text field on the main report and used the sum function, it works but only sums the first occurance.
Thanks in advance Jim
I have tried to sum from the page break section...but understand Access won't allow and an error is produced.
I have created a text field on the main report and used the sum function, it works but only sums the first occurance.
Thanks in advance Jim