DBWebApplications 





Access Data Manipulation  «Prev  Next»
Lesson 14 Create calculated controls
Objective Create a calculated control on a form.

Create calculated Controls in Access

Access Aggregate Calculations
You can create a calculated control on a report, but in general the place to create calculations is in a query or in a report form. The result of a calculation in a query can easily be displayed in a form if the query is used as the basis for the form.
To create a calculated control, you need to do two things:
  1. Create the new control.
  2. Type in the expression for the calculation.

The following SlideShow takes you through the process.



Add Access Calculated Control
The module wrap-up will review terms and concepts used in this module.

Create Calculated Controls - Exercise

Add a calculated control to the Hours Subform in this exercise.
Create Calculated Controls - Exercise