Sorry, forgot the report...
Select Top 1000000 htblticket.ticketid As ID,
htblticket.subject As Subject,
htblticket.updated As [Closed Date],
Sum(htblnotes.timeworked) As [Time Worked (Minutes)],
htblusers.name As Agent,
htbltickettypes.typename As [Ticket Type],
DatePart(mm, htblticket.updated) As Month,
DatePart(yy, htblticket.updated) As Year
From htblticket
Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Where DatePart(mm, htblticket.updated) = 10 And DatePart(yy, htblticket.updated)
= 2016 And htblticketstates.statename = 'Closed'
Group By htblticket.ticketid,
htblticket.subject,
htblticket.updated,
htblusers.name,
htbltickettypes.typename
Order By Agent