microsoft access 2013 tutorial 7 case 1 guide

If the Property Sheet is not already displayed, press F4 to display it. Select the control into which you want to enter an expression. In the Navigation Pane, right-click the form that you want to change, and then click Layout View or Design View on the shortcut menu. The Sum function calculates the total for all the values of table_field. That field can come from a table or a query. In this case, table_field is the name of the field that contains your subtotal values. To calculate the total, place a text box control in the report footer, and then set the ControlSource property of the text box to the following expression: =Sum() For example, suppose that you have a report that displays multiple inventory records, and you want to create a total in the report footer that sums all the line items on the report.

When you use an expression as the data source for a control, you create a calculated control.

The following sections show you how to create an expression step-by-step.Ĭalculate values for controls in forms and reportsĪdd a validation rule to a table field or record For example, determine how many days have passed since an order was shipped, or combine a FirstName and a LastName into a FullName. You can use expressions to do all kinds of things with your data.

Microsoft access 2013 tutorial 7 case 1 guide