I'm trying to filter a report by time which should be easy enough however I'm have an issue with data type mismatches.
Code is as follows:
Code:
Dim strWhere As String
Begin = Format(Me!TimeFrom.Value, "hh:mm:ss")
Finish = Format(Me!TimeTo.Value, "hh:mm:ss")
strWhere = "[Deadline4] >='" & Begin & "' AND [Deadline4] <='" & Finish & "' AND [Day] = date()"
DoCmd.OpenReport "Reports_DateRange", acViewReport, , strWhere
Deadline 4 is date/time and is entered as the time part only. Any help would be greatly appreciated.