How to Use AVG Function MS Access

‍

‍

Here’s how to do it:

‍

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Add the table containing the field you want to average by clicking the 'Add Selected Tables'.
4. Drag the desired field into the query grid.
5. Click on the 'Totals' button in the ribbon.
6. In the 'Total 'row under your field, select 'Avg' from the dropdown.
7. Run the query by clicking the 'Run' button.