Group by Day of the Week and Time Report

  • Thread starter Thread starter Demian Valle
  • Start date Start date
D

Demian Valle

I am working with a table that has a date/time field
called event_date. I am trying to create a report that
counts the number of records in the table where event_date
falls within a certain half hour interval and that also
shows the count of records where event_date falls on a
given day of the week.

Here is an exmaple of what I am trying to create:

Sun Mon Tue Wed Thu Fri Sat
7:00-7:30 7 0 6 4 9 4 9
7:30-8:00 6 6 14 12 1 9 12
8:00-8:30 13 1 8 0 20 3 1
8:30-9:00 8 5 7 10 4 12 9
etc.

Any ideas?
 
How would you count an event that crosses more than one time range?
I would start with a time range table. It should include the min, max, and
title of each time range (used as your row headings on the left).
 
Back
Top