Filter Report by Time

[Tyork]

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:

 
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.

[NTC]

guesses/distractions: begin & finish not dimmed, Day is reserved word I think, is there the correct "'" around Day= portion of statement??-not sure

have you considered putting the criteria in the underlying record source query rather than the opening argument? might be easier....

hope this helps a little.

[pbaldy]

The type mismatch is because in Access, date/time values need to be surrounded by # rather than ' (which is for text values).

[Tyork]

Thanks pbaldy, I appreciate the help.

[pbaldy]

No problemo.