Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

You can also use the Expression Builder to create a calculated field by selecting any blank Field row and clicking the Builder button on the Design tab.



Procedures

1. Open the desired query in Design view. 2. Select any blank Field row. 3. Type the desired field name and a colon (:). 4. Type the expression required to perform the calculation. 5. Press [Enter] .



Step-by-Step

Create a calculated field in a query.

Open the Reps Pay Query query in Design view.

Steps

Practice Data

1. Select any blank Field row.

Click in the Field row to the right of Commission Rate

The insertion point appears in the corresponding Field row.

2. Type the desired field name and a colon (:). The text appears in the Field row. 3. Type the expression required to perform the calculation. The expression appears in the Field row.

Type Commission:

Type [ord tot]* [commission rate]

4. Press [Enter] .

Press [Enter]

The calculated field is entered into the design grid.

Run the query. Notice that the Commission field displays the results of the value in the Ord Tot field multiplied by the percentage in the Commission Rate field.

OFFICEPRO, Inc.

Page 73