I am trying to produce a report that count the number of incidents for a month by hour.

I would like to use the timestamp to count the number of incidents inserted into the database and pull the time from timstamp to place in the correct category.

Example

          Month & Year: October, 2009

Time Reported        # Of Incidents Reported

 7:00 AM                            10   

 8:00 AM                            12   

 9:00 AM                            18  

10:00 AM                           20   

11:00 AM                           30

12:00 PM                           25 

 1:00 PM                            15   

etc.    

What would be the best way to approach this? Anyone have any examples????