Tue 26 Jun 2007, 16:25Delegate Henrietta said...
Henrietta has attended:
Excel VBA Intro Intermediate course
Calculate a report
How do I total all the numbers in a report?
Mon 2 Jul 2007, 13:10Trainer Carlos said...
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
