Use a formula in a query

Another common way to alter the selection criteria in a query is to add a function. For example, if you want to know how much your company spent on office furniture last year, you can add an aggregate function to the query and the sum will appear in your results.

1. Open your query in Design view.

2. On the Design tab, in the Show/Hide group, click Totals. The Total row appears in the designer.

3. In the field where you want to use the function, click the Total row and select a function from the list.

4. When you run your query, the results include your calculation.

You'll use functions during the practice. Next, let's look at creating a select query that uses more than one table.

Topic 6 of 9

Previous | Next

(Back to Start)