If I have a report called RepMain and in that report i have a sub-report called SubRepOne and in that sub-report I have a column called Cost how can I make a text box on the main report to total that one column in the subreport?
Add an unbound text box to the report footer of your subreport and set its control source to:
Code:
=Sum([Cost])
. In the text box of your main report that you want to display the total, set its control source to the text box from your subreport's footer (something like:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.