Help! Averaging # of Claims during a time period

[proflola]

Hello,

I have a query that shows Total Closed Claims processed during a specific time period such as Between 6/1/2007 and 9/20/2007.

I used the COUNT function on a Case# in a Totals query to give me the total claims processed during the time period, but I'm not sure how to do it for the averages.

Any help would be most appreciated.

Thanks again!
SJD

 

[PHV]

Have you tried to use the AVG function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886