Hi guys,
I have an access database of basically support tickets received, includes a few fields but mainly lets concentrate on ticket received time. It is a full date with date and time received.
I want to query on this and create a histogram which shows each hour, or 2, or 3 hours as bins for the histogram and how many tickets are received in that time - to basically show our busiest times of the day.
I did this easily in Excel, by extracting the hour portion of the time of all the tickets and using a simple "Frequency" equation and defining the bins how I wanted them.
Now I have this information in an Access database, how can I create a query/report that can replicate what I did in Excel?
I'm sure after hours and days of googling I could get there myself - but with the combined wisdom of OcUK I'm sure this would be faster
Thanks!
I have an access database of basically support tickets received, includes a few fields but mainly lets concentrate on ticket received time. It is a full date with date and time received.
I want to query on this and create a histogram which shows each hour, or 2, or 3 hours as bins for the histogram and how many tickets are received in that time - to basically show our busiest times of the day.
I did this easily in Excel, by extracting the hour portion of the time of all the tickets and using a simple "Frequency" equation and defining the bins how I wanted them.
Now I have this information in an Access database, how can I create a query/report that can replicate what I did in Excel?
I'm sure after hours and days of googling I could get there myself - but with the combined wisdom of OcUK I'm sure this would be faster
Thanks!