Microsoft Office Tutorials and References
In Depth Information
To Calculate Statistics
The following steps create a new query for the Client table, include the Total row in the design grid, and then
calculate the average amount paid for all clients.
1
Create a new query
with a fi eld list for
the Client table.
Design tab
If necessary, click
Design on the
Ribbon to display
the Design tab.
Totals button
Add the Amount
Paid fi eld to
the query.
Click the Totals
button on the Design
tab to include
the Total row in
the design grid
(Figure 2-66).
Amount Paid
fi eld added to
query
Total row
current entry in
Total row
Figure 2–66
2
Click the Total row in the Amount
Paid column to display the Total
box arrow.
Click the Total box arrow to
display the Total list (Figure 2–67).
Total box
arrow
Total list
Avg
(average)
Figure 2–67
Search JabSto ::




Custom Search