Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Jan 12th, 2018 41 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. 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]
  2. FROM tblStudentCourses
  3. GROUP BY tblStudentCourses.SalesID, Format$([tblStudentCourses].[SignDate],'mmmm yyyy'), Year([tblStudentCourses].[SignDate])*12+DatePart('m',[tblStudentCourses].[SignDate])-1;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top