Code:stroverlapQuery = "SELECT SUM(a.Overlapping) AS RESULT FROM " & _ "( " & _ "SELECT " & _ "CASE " & _ "WHEN ('" & strStartTime & "' BETWEEN Start_Time AND End_Time) OR ('" & strEndTime & "' BETWEEN Start_Time AND End_Time) " & _ "OR ('" & strStartTime & "' < Start_Time AND '" & strEndTime & "' > End_Time) OR ('" & strStartTime & "' > Start_Time AND '" & strEndTime & "' < End_Time) " & _ "THEN 1 " & _ "ELSE 0 " & _ "END As Overlapping " & _ "FROM dbo_tbl_Exceptions " & _ "WHERE " & _ "Exception_Date = '" & strExceptDate & "' AND EMP_ID = '" & strEmpID & "' " & _ ") a " intResult = CurrentDb.OpenRecordset(stroverlapQuery).OpenRecordset.Fields("Result")