Averages in Queries

[Guest]

How would I do a Query to give me Averages?

Ex..
Average [Days Outstanding] by [Vendor]

also how do I get Totals

Ex..

Total [Review Cost] by Vendor

 

[Roger Carlson]

In the Query Builder, click the Totals button (looks like a Greek Sigma).
It will change the query to a Totals (or aggregate) query. Add a table to
the top part and then drag Vendor and Days Outstanding into the grid.
Select GroupBy in the Totals line for Vendor and select AVG in the Totals
Line for Days Outstanding.

For the second question, use the SUM function.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks, I feel like an idiot on the second question. Duh

Thanks again.

In the Query Builder, click the Totals button (looks like a Greek Sigma).
It will change the query to a Totals (or aggregate) query. Add a table to
the top part and then drag Vendor and Days Outstanding into the grid.
Select GroupBy in the Totals line for Vendor and select AVG in the Totals
Line for Days Outstanding.

For the second question, use the SUM function.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

How would I do a Query to give me Averages?

Ex..
Average [Days Outstanding] by [Vendor]

also how do I get Totals

Ex..

Total [Review Cost] by Vendor