Access Averaging

  • Thread starter Thread starter Sal
  • Start date Start date
Use the AVG aggregate function in a Totals query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Thanks for that John.
I am sorry to appear daft, but do i put this in the query
window as =Sum(FieldName)
Thanks again
Sal
 
Sal-

Start a query on your table. Click the Totals button on the toolbar (Greek
Sigma) or choose Totals from the View menu. Add the fields you want, and
choose Avg on the Totals line under the field you want to average. Ditto
Sum, Min, Max, etc. You can include a field multiple times if you want to
do several different calculations - such as the Avg and the Sum.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top