Where is the access calculation control?

Where is the access calculation control? Which is the access calculation control?

The calculated control is an ordinary control. You only need to set the "control source" property of the control to [=calculated expression]. Example:

Add a text box "Text1" to the form, then select the control in the form design view and enter the expression directly on the control (you can also enter the "Control Source" property bar of the control Fill in): =[Text2]*[Text3]

In this way, the text box "Text1" is set as a calculation control, and the product of the values ​​in the other two text boxes will be automatically displayed.

Extended information

Usage of calculation control:

1. If you need more space to facilitate in the "Control Source" property box , press Shift F2 to open the Zoom box.

2. If the form or report is based on a query, it is best to place the expression in the query rather than in the calculated control. Doing this improves performance and makes it easier to use in aggregate functions (aggregate functions: functions used to calculate totals) if you are calculating a total for a group of records.

For example: Sum, Count, Avg or Var.) (Calculated field: A field defined in a query that displays the result of an expression rather than the stored data. Whenever the value in the expression changes, the value is recalculated.) .

3. When sorting calculated controls in a form or report, please ensure that the "Format" property of the control is set correctly. Otherwise, calculated numeric or date values ​​may be sorted alphabetically rather than numerically.

php Chinese website, a large number of free access database tutorials, welcome to learn online!

The above is the detailed content of Where is the access calculation control?. For more information, please follow other related articles on the PHP Chinese website!