How to Take the Average of a Query in Access

Save

Taking the average of a query in Access is done by using the Average function as your develop the query. Queries offer lots of flexibility when you need to extract data and perform calculations on data in your database. Generating an average can be done using the Totals button when the query is in the datasheet view. This quick feature can be done to queries that already exist. Use this feature when you need a quick calculation on the queries in your database.

  • Open Access 2010 and select a database. Click the "File" tab and select the "Open" icon. Search the files for the database. Click the database and select the "Open" button. The database opens.

  • Click the drop-down list in the Navigation Pane. Select "Object Type." Click the Navigation Pane's drop-down list. Click "Queries." The Navigation Pane displays all of your queries.

  • Double-click on one of the queries to run it. Review the query results in the datasheet view. Click the "Totals" button on the ribbon. Notice the total field that appears beneath your data in your query. Click the Totals drop-down list on the column where the average will occur. Select the word "Avg." Access displays the average of this column.

References

Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!