Do a grouping by year

• Arthur.Lorenzini

  SSCrazy

  Points: 2312

  More actions

  April 28, 2011 at 9:44 pm

  #235469

  I am trying to write a script that will group by year based on a date:

  SELECT Count(qlkpApplicantWaitingListMain.ApplicationID) AS TotalCount, qlkpApplicantWaitingListMain.[Approval Date]

  FROM qlkpApplicantWaitingListMain

  GROUP BY qlkpApplicantWaitingListMain.Status, qlkpApplicantWaitingListMain.[Approval Date]

  ORDER BY qlkpApplicantWaitingListMain.[Approval Date];

  I am trying to get to:

  Total Count Year

  34 2006

  45 2007

  .

  .

  .

  This needs to be based on the column qlkpApplicantWaitingListMain.[Approval Date]

  Any advice?

  Warm Regards,

  Arthur Lorenzini
  Sioux Falls, SD

• Arthur.Lorenzini

  SSCrazy

  Points: 2312

  More actions

  April 28, 2011 at 10:06 pm

  #1317657

  Solved my own problem....

  Must be getting tired.

  SELECT Count(qlkpApplicantWaitingListMain.ApplicationID) AS TotalCount, Year(qlkpApplicantWaitingListMain.[Approval Date])

  FROM qlkpApplicantWaitingListMain

  GROUP BY qlkpApplicantWaitingListMain.Status, Year(qlkpApplicantWaitingListMain.[Approval Date])

  Warm Regards,

  Arthur Lorenzini
  Sioux Falls, SD