SELECT DISTINCTROW tblStudentCourses.SalesID, Format$([tblStudentCourses].[SignDate],'mmmm yyyy') AS [SignDate By Month], Sum(tblStudentCourses.Fee) AS [Sum Of Fee], Avg(tblStudentCourses.Fee) AS [Avg Of Fee], Count(*) AS [Count Of tblStudentCourses]
FROM tblStudentCourses
GROUP BY tblStudentCourses.SalesID, Format$([tblStudentCourses].[SignDate],'mmmm yyyy'), Year([tblStudentCourses].[SignDate])*12+DatePart('m',[tblStudentCourses].[SignDate])-1;