I have an SQL statment I use to creat a report. The report allows the user to fill in a data range and a Time range. The SQL Statement works correctly if I use just the date range. Now that I am trying to implement the Time range, I have ran into problems. I finally got it to work without syntax errors using the following code:<BR><BR>strSQL = "SELECT Dispatch.*, Dispatch_Type.Type_ID, Dispatch_Type.Timercvd"<BR> strSQL = strSQL & " FROM Dispatch LEFT JOIN Dispatch_Type ON Dispatch.Dis_ID = Dispatch_Type.Dis_ID"<BR> strSQL = strSQL & " WHERE (Dispatch.Dis_Date Between '" & frmCAD_History.Start_Date & "' And '" & frmCAD_History.End_Date & "') and (Dispatch_Type.Timercvd >= '" & CDate(Start_Time) & "' And Dispatch_Type.Timercvd <= '" & CDate(End_Time) & "')"<BR> strSQL = strSQL & " ORDER BY Dispatch.Dis_Date DESC"<BR><BR>But now my report is not showing any data and it should be showing 5 records. The default values for the times are <BR><BR>Start_Time = 12:00:01 am<BR>End_Time = 11:59:59 pm<BR><BR>any ideas what I am doing wrong?