Why is this statement rejected?
Code:sSQL = "SELECT * FROM EquipRunTime WHERE pond = '" & rsPonds!pond & "' " & _ "(thedate BETWEEN #" & Format(DateAdd("h", -24, dtCurrent), "General Date") & "# AND #" & _ Format(dtCurrent, "General Date") & "#)AND NOT Cleared ORDER BY thedate DESC"




Reply With Quote