How to pull data between two dates and only at a certain time of each day?

[akibasaimon]

Hi All,

The company I work for has 2 shifts. The managers on the different shifts want to be able to look at the data for their shift only. Therefore I've been working on trying to create the code to allow our users to search for data between specific date parameters (i.e a week) and for each day of that week to only look between a specific time range (i.e 09:00 to 17:00). The date parameters can be selected by the user while the time parameters are preset to certain intervals.

Any ideas how this can be done?

[pbaldy]

With no idea of your structure, I'd suggest looking at DateValue() and TimeValue(), along the lines of:

SELECT...
FROM...
WHERE DateValue(DateTimeField) Between Date1 And Date2 AND TimeValue(DateTimeField) Between Time1 And Time2

[Dal Jeanis]

If there are only two shifts, you can also consider just marking the database records with a shift code. After that was done, any query could just use a filter on shift code, if the user wanted only one shift to be displayed.

[rpeare]

I'd go with pbaldy's method. You can make the default time range based on the time the report is run, so if it's between 9 and 5 filters one way, if it's after 5pm it filters another

Filtering can either be done using the filter property of the report or through the query running the report.