How do I add a total to a subreport e.g. I want a sum total for the records in the subreport? I can see the "totals" item under the "groupings and totals" menu, but it is greyed out / disabled.
Adding a total to a subreport?
Advanced Beginner
Windows 7 
Access 2007
How do I add a total to a subreport e.g. I want a sum total for the records in the subreport? I can see the "totals" item under the "groupings and totals" menu, but it is greyed out / disabled.
Last edited by degras; 01-20-2011 at 09:09 AM.
Who is John Galt?
Windows XP Access 2007
I would expect a textbox in the report footer with a control source like:
=Sum(FieldName)
Advanced Beginner
Windows 7 Access 2007
OK, thanks, that worked.
Who is John Galt?
Windows XP Access 2007
Posting Permissions
Reply With Quote