Use a formula in a query

Using 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)

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.