Creating a calculated control
Create a calculated control in Report Design view.
The best way to create a calculated control, especially if you want to aggregate data, is to use the Report Wizard. Even when the Report
Wizard doesnt give you exactly what you want, its far easier to edit a calculated control than to create one from scratch.
That said, however, it is possible to create calculated controls--in fact, the process is identical to creating a calculated control in a
form: create the text box and type the expression into it.
One difference from a form is that an aggregate calculation is much easier to create on a report. Expressions for aggregate expressions need
to be put in the correct place on the report. If you are aggregating all the data for one company, for instance, the correct place to put the
expression is in the Company header or footer.
Access uses the same common functions used by Excel. The simple ones that you might want to use are:
Avg, Sum, Count, Min, and
Max. Access has many more functions than these, and theyre all listed in the Help system.
When you write an expression, do not forget the special characters that Access needs: notably, field names must be enclosed in square
Creating Calculated Control - Exercise
Click the View Table Link to review the chart of special characters.
Learn to add page breaks your report, in the next lesson.