Date/Time Range in reports

[gofish23]

I have a Work Order Table that automatically enters a date and time stamp to each record. I'm trying to run a report, first using a form to query the user for a beginning and end date for the report. Everything works except that I do not show the work orders on the report that are equal to the end date. I'm assuming that this is due tot he fact that the time stamp makes it greater than the base date value. I'm using the following experession to filer the record:

>=[forms]![Report Date Range Location]![Beginnining Date] And <=[forms]![Report Date Range Location]![Ending Date]

Thanks for the help.

 

[BobJacksonNCI]

I thought you'd have an answer by now. I know what's missing (time) but am unsure of the syntax...

>=(datevalue([forms]![Report Date Range Location]![Beginnining Date]) + timevalue(#00:00:00#() And <=(datevalue([forms]![Report Date Range Location]![Ending Date]) + timevalue(#23:59:59#))

If this doesn't work, hopefully someone will give you a proper method to include the time with your date fields.


HTH,
Bob
Thread181-473997 provides information regarding this site.

 

[BobJacksonNCI]

OOPS!

>=(datevalue([forms]![Report Date Range Location]![Beginnining Date]) + timevalue(#00:00:00#)) And <=(datevalue([forms]![Report Date Range Location]![Ending Date]) + timevalue(#23:59:59#))


HTH,
Bob
Thread181-473997 provides information regarding this site.

 

[gofish23]

That did it, thanks for the help!