Help on grouping by TIME Range

[WimDC]

thread701-1483093

Hi,

I found thread 1483093 about grouping records by time range
The suggestion / solution that user PHV has given works perfectly.

Now, I want to extend my query to combine both day of week and time ranges.
(my table has 2 different fields: one with the date and one with the time)

Something like (last column is count of records):

[tt]
MONDAY 00:00-00:59 - 15
MONDAY 01:00-01:59 - 444
...
MONDAY 23:00-23:59 - 6
TUESDAY 00:00-00:59 - 15
TUESDAY 01:00-01:59 - 444
...
TUESDAY 23:00-23:59 - 6
...
...
SUNDAY 00:00-00:59 - 15
SUNDAY 01:00-01:59 - 444
...
SUNDAY 23:00-23:59 - 6[/tt]

Has someone a solution?

Wim

 

[dhookom]

Can you provide your current expression used for the time? I expect you could simply add the date field to the time field and the group on the result.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016