Subject: GROUP BY clause · Posted: 2005-11-07, 02:30pm
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!!
Stick and Stones may break my bones but Caricatures will cause a riot!