How to Average Time for Week

[chiassg]

Here's the code that's currently being used to show average time for a month. We'd like to show average times for the week. Can you assist? Thanks. Gayle

SELECT Months.monthname, Avg(Minute([cust_time])) AS Wait, Customer.cust_month
FROM Months INNER JOIN Customer ON Months.monthid=Customer.cust_month
GROUP BY Months.monthname, Customer.cust_month
HAVING (((Customer.cust_month)=Forms![Monthly Report]!monthid))
ORDER BY Customer.cust_month;

 

[PHV]

Provided the Customer table has a DateTime field you may consider grouping by DatePart("ww", [DateTimeField])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886