98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course - Calculate a report
microsoft access course - Calculate a report
Resolved · Low Priority · Version Standard
Henrietta has attended:
Excel VBA Intro Intermediate course
Calculate a report
How do I total all the numbers in a report?
RE: Calculate a report
Hi Henrietta
To calculate all the numbers in a report for an Overall total:
In the Report's Design View
Place a text box in the Report Footer
Right click the text box and select Properties
In the Properties dialog box
Select [/b] Data[/b] And Control Source
Open the [/b]Expression Builder[/b] and enter the following formula:
=Sum([The field containing the Total])
Run the Report
Regards
Carlos
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Copy a Previous Record's Values to a New RecordIf you often enter the same value in one field of a table, there are two methods to save re-typing the data. |