Calculating a monthly average

U

UGA Ag Dawg

I have weekly data for several years and would like to calculate the average
by month by year. Can this be done in Access?
 
M

Michel Walsh

Hi,


Yes. Yuo can group on computed expression:

SELECT ...
FROM ...
GROUP BY Year(DateTimeStamp), Month(DateTimeStamp)



Hoping it may help,
Vanderghast, Access MVP
 
Top