Agregate function dates

[chip0312]

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

[Larry Linson]

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