I have a maintenance tracking database I'm building. I have created a report that will list the history of what work orders a technician has worked on. I have a calculated field where I subtract the stop time from the start time and then display the minutes the technician was working. When I group the results by date, I want to add all the minutes together and present a total time the technician was active for the day. However, when I try to total on the group and select the "Minutes" field it only gives me "Count Values" and Count Records", but will not allow "Sum". Below is the SQL I used for the report. The area in question is highlighted. Any ideas?
SELECT tblEmployees.intEmployeeID, tblEmployees.txtEmployeeName, Year([tblWorkOrder]![dtDateTimeCreated]) & "-" & Format([tblWorkOrder]![lngSequence],"0000") AS [Work Order], tblMachineID.txtMachineID, Format([tblWorkData]![dtWorkStartDateTime],"mm/dd/yyyy hh:nn") AS [Start], tblWorkData.dtWorkStopDateTime, Format([tblWorkData]![dtWorkStopDateTime],"mm/dd/yyyy hh:nn") AS [Stop], Format(DateDiff("s",[tblWorkData]![dtWorkStartDateTime],[tblWorkData]![dtWorkStopDateTime])/60,"Fixed") AS Minutes, tblWorkData.txtWorkComments
FROM (tblEmployees INNER JOIN tblWorkData ON tblEmployees.intEmployeeID = tblWorkData.lngTechID) INNER JOIN (tblMachineID INNER JOIN tblWorkOrder ON tblMachineID.anMachineID = tblWorkOrder.intMachineID) ON tblWorkData.lngWOSequence = tblWorkOrder.lngSequence
WHERE (((tblWorkData.dtWorkStopDateTime) Is Not Null))
ORDER BY tblEmployees.txtEmployeeName, Year([tblWorkOrder]![dtDateTimeCreated]) & "-" & Format([tblWorkOrder]![lngSequence],"0000");