How to make this access query?

Docaroo

Docaroo

Docaroo

Soldato
Joined
27 Jun 2005
Posts
2,863
Location
Aberdeen, Scotland
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!
 
You can't create a histogram in access... it's got none of that diagram thing going on that you can do in excel... it's a database - not a spreadsheet. ie - it's for storing data, not for showing it.

You could import the data from access into excel and then create your histogram.

Or you could write a script that reads the data from access and draws a histogram.

Seeing as you want data from each row, I'd just use the query to retrieve the data, then script the frequency calculations. You could do it in SQL but it would be more complicated and less penetrable if you wanted to amend it.
 
inogen please dont give bad advice.
you CAN create a histogram in access.
you need to use PARTITION in the query: PARTITION(Number, Range Start, Range Stop, Interval)

then enable pivot view.
 
You must log in or register to reply here.
Back
Top Bottom