Rank: ? (1224)
Member #: 15685

Im kinda having trouble with the GROUP BY Clause

I have a table in my access database which captures the date...now i want to display the data but i want it group by the month.....but all i have is the date column....is there any way to just group by the month using my date column?

I found a GROUP BY Datepart(mm,date) function on the net but i have no idea how to use it....its giving me errors.

BTW i'm using ADO and ASP to display my data

Thanks in Advance!!