|
Exam 77-885: Microsoft Access 2010
5. Designing Reports
5.2. Apply Report Design options: Add
a Calculated Control
Report Design Tools ->Design-> Grouping and
Totals->Group &Sort Our goal
is to add Totals for each Group as well as for the entire Report.
Basically, a Total is a Text Box that has an expression instead of a
Control Source. It is a
Calculated Control: an Expression that Counts the Records in
each Group. 4. Try it:
Create a Calculated Control Go to
Group, Sort and Total. Select a
Group: Genre. Edit the
Totals as follows: Total on:
Genre. Type:
Count Values Show
subtotal in Group Footer. Keep
going... |
|
| |
