Re: (sql) Group by Month query

My understanding is that you cannot use GROUP BY in your SQL. This goes into the CFOUTPUT tag. Have you tried SELECT DateJoined, Year(Month(DateJoined)) as MonthCount, Count(Year(Month(DateJoined))) as MonthJoinedCount FROM Admin ORDER B

RE: (sql) Group by Month query

The problem is you are still grouping on the specific dateJoined. Try something like SELECT Month(DateJoined) + ' ' + Year(DateJoined) as monthJoined, Count(*) as MonthJoinedCount FROM Admin GROUP BY Month(DateJoined) + ' ' + Year(DateJoined) ORDER BY Count(*) DESC -Original Message-