G Guest Nov 19, 2004 #1 I have weekly data for several years and would like to calculate the average by month by year. Can this be done in Access?
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 Nov 19, 2004 #2 Hi, Yes. Yuo can group on computed expression: SELECT ... FROM ... GROUP BY Year(DateTimeStamp), Month(DateTimeStamp) Hoping it may help, Vanderghast, Access MVP
Hi, Yes. Yuo can group on computed expression: SELECT ... FROM ... GROUP BY Year(DateTimeStamp), Month(DateTimeStamp) Hoping it may help, Vanderghast, Access MVP
