Date Range Failure

[goodguy]

I have a ReportFilter form with this code in the button:

DoCmd.OpenReport "JobsReport", acViewPreview, , "outTime>=#" & (StartDate) & "# and outTime<= #" & (EndDate) & "#"

It works OK, except that the report excludes the current day's records. Or, possibly, I should say, the last day's records. I've tried tweaking the '<' and '>' with '=' and '+1' etc to no avail.
What could be wrong?

[RuralGuy]

All DateTime fields have a Time component. If you just use the Date then the Time is set to 0 or midnight at the beginning of the day. In this case I usually just add another day to the EndDate.

[goodguy]

As I said, I have tried '<+1' and '>+1' in vain.

[RuralGuy]

Between is inclusive. Give it a try:

DoCmd.OpenReport "JobsReport", acViewPreview, , "[outTime] Between #" & (StartDate) & "# AND #" & (EndDate) & "#"

[goodguy]

Will do, thanks.