Hey I'm having a slight problem with this figuring out how to take my query to the next level..
What I'm trying to do is to display the sum of hours for each client related to a specific employee...
As of right now, my query sums up the whole month and displays it.
It should look like this on my page...
Company 1 12hrs
Company 2 20hrs
Company 2 40hrs
Total Company 1 Hours 12
Total Company 2 Hours 60
SELECT SUM(HSPENT) AS monthsum FROM Timesheets LEFT JOIN Clients ON Clients.ClientID = Timesheets.ClientID WHERE Timesheets.EmployeesID =
<CFQUERYPARAM cfsqltype="CF_SQL_INTEGER" value="#URL.EmployeesId#">
and month(ddate) = #url.m#