I am creating a stock report and at the end of each section I want to put a sub total, then at the end of the report put a grand total.
Any help would be greatly appreciated.
In the report footer put a text box with the control source =Sum(YourField). This will give you the grand total for that field. Of course, this will only work with a field that is part of the record source of the report.
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.