on this query?
SELECT qryEmployeeHoursXLSWithLCDesc.LABORCATEGORY, qryEmployeeDataXLS.Expr1, qryEmployeeDataXLS.[PERSONNEL SURNAME], qryEmployeeDataXLS.[PERSONNEL FORNAME] AS Expr2, qryEmployeeHoursXLSWithLCDesc.REVIEWED, Sum(qryEmployeeHoursXLSWithLCDesc.FRIDAY) AS SumOfFRIDAY, Right$([laborcategory],2) AS LC, qryEmployeeHoursXLSWithLCDesc.LaborCategoryDesc
FROM qryEmployeeDataXLS LEFT JOIN qryEmployeeHoursXLSWithLCDesc ON qryEmployeeDataXLS.[PERSONNEL ID NR] = qryEmployeeHoursXLSWithLCDesc.[PERSONNEL ID NR]
GROUP BY qryEmployeeHoursXLSWithLCDesc.LABORCATEGORY, qryEmployeeDataXLS.Expr1, qryEmployeeDataXLS.[PERSONNEL SURNAME], qryEmployeeDataXLS.[PERSONNEL FORNAME], qryEmployeeHoursXLSWithLCDesc.REVIEWED, Right$([laborcategory],2), qryEmployeeHoursXLSWithLCDesc.LaborCategoryDesc
HAVING (((qryEmployeeDataXLS.Expr1) In ((qryEmployeeHoursXLSWithLCDesc.REVIEWED) Between [Forms]![frmReportSelector]![txtDateStart] And [Forms]![frmReportSelector]![txtDateEnd])))
ORDER BY qryEmployeeHoursXLSWithLCDesc.LABORCATEGORY, qryEmployeeDataXLS.Expr1, qryEmployeeDataXLS.[PERSONNEL SURNAME], qryEmployeeDataXLS.[PERSONNEL FORNAME], qryEmployeeHoursXLSWithLCDesc.REVIEWED;