By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Agregate function dates

P: n/a
I am trying to group my avergaes by month. However, when I run the
query, I received the averages but by day. I neeed to group these
averages by month. Thanks in advance for your help. The table has 2
colums 1 column for raw numbers 2nd column for the day. This is the
out I get when I run my query but the averages are group by day for
January

6.762790698 1/2/2004
6.708717949 1/5/2004
6.72 1/6/2004
6.690588235 1/7/2004
7.15375 1/8/2004
7 1/9/2004
6.395208333 1/12/2004
7.291111111 1/13/2004
6.942413793 1/14/2004
6.948076923 1/15/2004
7.337419355 1/16/2004
7.015901639 1/20/2004

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use the Month built-in Function and group on that (and year, if you have
mutliple years in the sample).

Larry Linson
"chip0312" <op***@asgardfinancial.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I am trying to group my avergaes by month. However, when I run the
query, I received the averages but by day. I neeed to group these
averages by month. Thanks in advance for your help. The table has 2
colums 1 column for raw numbers 2nd column for the day. This is the
out I get when I run my query but the averages are group by day for
January

6.762790698 1/2/2004
6.708717949 1/5/2004
6.72 1/6/2004
6.690588235 1/7/2004
7.15375 1/8/2004
7 1/9/2004
6.395208333 1/12/2004
7.291111111 1/13/2004
6.942413793 1/14/2004
6.948076923 1/15/2004
7.337419355 1/16/2004
7.015901639 1/20/2004

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.