Access,+Using+the+Avg+Function+In+a+Query

These steps will help describe how to use the average function in a query on Microsoft Acess. These are steps shown from the Sam2007 tutorial.


 * 1) Open Microsoft Access
 * 2) Click the Querry Tools Design Tab on the ribbon
 * 3) The Querry Tools Design Tab contains options for changing the querry type and setup.
 * 4) In the Show/Hide group on the Querry Tools Design Tab, click the Totals button.
 * 5) The Total row is added to the querry design grid.
 * 6) In the Inventory1 table field list, double-click the Rental Price field.
 * 7) The field is added to the querry design grid.
 * 8) In the querry design grid, click the Total text box for the Rental Price field.
 * 9) The Total text box displays an arrow.
 * 10) On the Total text box for the Rental Price field, click the arrow.
 * 11) Clicking the arrows displays the list of functions that you can use in the field.
 * 12) In the list, click Avg.
 * 13) The Avg function is added to the Total text box for the field.
 * 14) In the Field text box for the Rental Price field, select Rental Price.
 * 15) The field name is selected.
 * 16) Type **AVG Price: Rental Price.**
 * 17) The new field name includes the new name and the original field name, seperated by a colon.
 * 18) Press ENTER.
 * 19) When you run the query, the name to the left of the colon will be displayed as the column heading in the query datasheet.
 * 20) In the Results group on the Querry Tools Design tab, click the Run button.
 * 21) The querry displays the average price for each group in the calculated field.