DoCmd.OpenReport

[ccordner]

Hi

I am trying to open a report through VBA, subject to a condition. I am using the following line:

.DoCmd.OpenReport "rptSupervisorsLogHistoric", acViewPreview, , "[DateReported]>" & DTP1.Value, acHidden

DTP1 is a Microsoft Date & Time Picker.

I tried

=" & DTP1.Value

But that came up with no records, so I changed it to ">" but that returns all records.

How can I set it to say between 4am on DTP1.Value and 3:59am on DTP1.Value+1?

Thanks
Chris