Hi
I am trying to open a report through VBA, subject to a condition. I am using the following line:
DTP1 is a Microsoft Date & Time Picker.
I tried
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
I am trying to open a report through VBA, subject to a condition. I am using the following line:
Code:
.DoCmd.OpenReport "rptSupervisorsLogHistoric", acViewPreview, , "[DateReported]>" & DTP1.Value, acHidden
DTP1 is a Microsoft Date & Time Picker.
I tried
Code:
=" & 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