Microsoft Office Tutorials and References
In Depth Information
Creating summary data for records
Creating summary data for records
A datasheet allows you to easily change the presentation to
display summary data for any appropriate column, calculating a
count of the records, sum total, average, maximum, minimum,
variance, and standard deviation.
When you choose to close and save the changes to the
datasheet, any summary totals will be redisplayed when you next
open the datasheet. The summary calculations can be displayed
both for a datasheet and any subdatasheet, which is described
in the next example, “Displaying related information with a
Display totals for a datasheet
1 Open a datasheet.
2 Click the Totals button. (This will add a new row for totals to your
3 In the new row, select the type of summary required for a column.
Save the datasheet.
TIP Notice that on the right of the record selector we have a
plus sign. If you click this, it displays a subdatasheet, showing
the detailed records related to each parent record. In our sample
database, each Order record is related to several Order Details, and the
Order Details are displayed as a subdatasheet. This very powerful
feature of a datasheet allows you to drill down into associated details.
Search JabSto ::

Custom Search