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

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/...UBED1=ACCESS-L


"Casey P" <(E-Mail Removed)> wrote in message
newsC241429-B569-42A1-8BF1-(E-Mail Removed)...
> 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

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

Thanks again.

"Roger Carlson" wrote:

> 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/...UBED1=ACCESS-L
>
>
> "Casey P" <(E-Mail Removed)> wrote in message
> newsC241429-B569-42A1-8BF1-(E-Mail Removed)...
> > 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
>
>
>