& "IIf((DateDiff('n',[schCallTime],[schOutTime])/60)=24,0,(DateDiff('n',[schCallTime],[schOutTime])/60)) AS [TotalHours], " _
& "IIf((DateDiff('n',[schActualStart],[schActualEnd])/60)=24,0,(DateDiff('n',[schActualStart],[schActualEnd])/60)) AS [ActualTotalHours], " _
& "([ActualTotalHours]*[empRate]) AS [ActualAmount], ([TotalHours]*[empRate]) AS [ShiftAmount]," _
& "IIf([evtDescription]='Projects' Or [evtDescription]='VIP Management' Or [evtDescription]='Weekend Services','0','1') AS [tmpOrder] " _
& "FROM tblEmployeeStatus RIGHT JOIN (tblTypes RIGHT JOIN (tblLocations RIGHT JOIN (tblParts RIGHT JOIN (tblEvents RIGHT JOIN (tblEmployees INNER JOIN (tblDepartments RIGHT JOIN tblSchedule ON tblDepartments.depID = tblSchedule.schDepID) ON tblEmployees.empID = tblSchedule.schEmpID) ON tblEvents.evtID = tblSchedule.schEvtID) ON tblParts.prtID = tblSchedule.schPartsID) ON tblLocations.locID = tblSchedule.schLocID) ON tblTypes.typID = tblSchedule.schTypID) ON tblEmployeeStatus.ID = tblEmployees.empStatusID " _
strSQL = strSQL & "ORDER BY IIf([evtDescription]='Projects' Or [evtDescription]='VIP Management' Or [evtDescription]='Weekend Services','0','1'), [evtDescription]"
Session("strSQL") = strSQL
objCommand.CommandText = strSQL
Dim objDataReader As OleDbDataReader = objCommand.ExecuteReader()