Referencing textbox in subreport from main report

0
votes

I have a main report that I would like to have a textbox on that references the subreport. I used the format [Subreport].[Report]![Textbox] which did pull the textbox over. The problem I have is the textbox on the subreport contains a sum total (e.g. =SUM([SumOfTotalHours]). When the information appears on the main report, it does not display the total of hours; however, it shows only the first record in the textbox. For example, if the subreport had 3 records that were 1,2,3 and my sum total text box correctly shows 6, on the main report it would show 1. I'm not sure what I am missing here.

Thanks in advance.

1
ms-access

1 Answers

0
votes

You could try having a textbox, TxtSum, on the subreport with this ControlSource:

=Sum([SumOfTotalHours])

Then reference that on the main report:

=[Subreport].[Report]![TxtSum]