Paul has attended:
Excel Intermediate course
PowerPoint Introduction course
Access Introduction course
Excel Advanced course
Access introduction
How do you subtotal on reports?
RE: Access introduction
Hi Paul
To create a subtotal in the report you first need to have a report with a Group Header and Footer.
The Group Header contains the value for which you need the sub totals
To create a Group Header and Footer area:
1. Click the Sorting and Grouping button on the toolbar
2. Change to Yes the Property for the Group Header/ Footer as required
In the report make sure the item to be grouped eg Productname is in the Group Header area. (This groups all the like products together)
To add a Sub Total:
1. In the Group Footer area place a Text box in line with the numeric value in the Detail area eg Amount
2. In the Text box add the code =Sum([Amount])
3. When the report is run, the Sub Total will appear everytime a new product group appears.
If the above is done in the Report Footer area the system will produce a Grand total of the selected value
Hope this helps
Carlos
