SELECT dbo_tblIO_Rej.dtoDateTime, dbo_tblIO_Rej.LineID, dbo_tblIO_Rej.EquipmentID, dbo_tblIO_Rej.Inspected, dbo_tblIO_Rej.Rejected, dbo_tblIO_Rej.DayNoUTC, CDate(Left([dtoDateTime],10)) AS RejDate, Left(Right([dtoDateTime],15),8) AS DynTime, CDate(IIf([DynTime]<"08:00:00",[RejDate]-1,[RejDate]))...