Hello folks,
Perhaps I've been starring at this too much. What I am trying to do with the following WHERE condition is replace BETWEEN with >= And < operands for my date range. I've played around with the placement of them to no avail. Any help is appreciated. Thank you much.
:banghead:
Perhaps I've been starring at this too much. What I am trying to do with the following WHERE condition is replace BETWEEN with >= And < operands for my date range. I've played around with the placement of them to no avail. Any help is appreciated. Thank you much.
Code:
DoCmd.OpenReport ReportName, View:=acViewPreview, _
WhereCondition:="VisitDate Between # " & Format(Me.FROMDTTbx, "mm\/dd\/yyyy") & _
"# And #" & Format(Me.TODTTbx, "mm\/dd\/yyyy") & "#"