I have a form that request information from the user (StartDate, StartTime, EndDate and EndTime)… the problem is that it’s not working. The only way I can get any data to show is when I remove the StartTime and EndTime. Only then will it pull the items from the StartDate and EndDate.
Here is what I have as my criteria: Between [Forms]![OpPROD_ALL]![StartTime] And [Forms]![ OpPROD_ALL]![EndTime] And Between [Forms]![ OpPROD_ALL]![StartDate] And [Forms]![ OpPROD_ALL]![EndDate]
Any help you can offer so that the users will be able to request a report based on a start and end date along with a start time and end time I would really appreciate it.
Side note: this is to pull date for 3rd shift (Example) 4/14/2013 10:00PM – 4/15/2013 10PM
A suggestion. You can store both date and time in the same field and it would simplify your database. Then, if you want to just view the date or just the time use formatting. I believe that all date date types store both the date and time and if one or the other is not entered it defaults, i.e, your time field may be storing the date 01/01/1900 along with your time and if that is so this could explain why you don't see anything.
I believe it was a matter of formatting. In your table you set format to short date, in your form again short date and then your report short date. I changed all of them to general date which also includes time and believe the filtering will work. You will need to enter your start and end with time:
Start: 4/28/2013 11:00:00 PM
End: 4/29/2013 8:00:00 AM
Incidentally, I noticed Gunther. Would that be Gunther International in Norwich, CT?
I’m needing to add Active Time + Idle Time = Total Time
Daily this works fine but when I do something with a date range over 24hrs it doesn’t work correctly. The fix you suggested, where would I apply that?
This is the same database as mentioned before with needed to date range query across 3rd shift .