I have some columns with hours. I want to simply display the total below each column. I would like to do this in the query results and in the reports that I create.
Can anybody point me in the right direction?
Competent Performer
Windows 7 64bit 
Access 2013
I have some columns with hours. I want to simply display the total below each column. I would like to do this in the query results and in the reports that I create.
Can anybody point me in the right direction?
VIP
Windows 7 64bit Access 2010 32bit
With query open, click Totals from the Records group of Home tab on ribbon.
But users should not interact with tables and queries. Use a report and do summary calcs on the report.
Textbox in footer section with expression: =Sum([field name here])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Displaying previous totals, and current totals, on a report
Totals showing across bottom of Datasheet view
Posting Permissions
Reply With Quote