Access 2016 Intermediate

Lesson 4 – Designing Advanced Queries

Access 2016

NOTE To perform more than one calculation on a field, you must add the field to the design grid a second time and create the desired expression.



Procedures

1. Open the desired query in Design view.

2. Select the Totals button

in the Show/Hide group on the Design tab.

3. Select the Total row in the field you want to calculate. 4. Select the Group By list. 5. Select the desired function.



Step-by-Step

Create a function query.

Open the Region Totals query in Design view. Run the query; notice that a Sales to Date field appears for each customer in the region. Then, switch back to Design view.

Steps

Practice Data

1. Select the Totals button in the

Show/Hide group on the Design tab. A Total row appears in the design grid. Click

3. Select the Total row in the field you want to calculate. A drop-down arrow appears in the corresponding Total field .

Click in the Total row in the Sales to Date field

4. Select the Group By list.

Click Group By

A list of available functions is displayed.

5. Select the desired function.

Click Sum

The function appears in the Total row.

Page 78

OFFICEPRO, Inc.