Group results Hourly 2

[Revolution1200]

Hi All,

I am struggling with this one,

I have the following data in an access database

Time Calls Offered
00:00 0
00:15 0
00:30 0
...
09:15 10
09:30 20

What i would like to do is to produce a report that groups the 15 minute time intervals into hourly intervals with a sum of the calls offered each hour.

Can someone help me with this?

Thanks

Stuart

 

[rjoubert]

- Create a report, set the Record Source property of the report to your table/query that contains the data you posted.

- Add a grouping to your report. Set the field/expression to =Hour([time]), display at least the group footer.

- In the group footer that you just added, add a textbox control. Set the Control Source property of the textbox to =Sum([Calls Offered])

Good Luck!

 

[Revolution1200]

Thanks For that - seems simple when you know how

Have a star

Stuart

 

[Revolution1200]

Hi,

Is there a way of producing these results in a query of some sort?

Thanks

Stuart

 

[PHV]

A starting point (SQL code):
SELECT Hour([Time]) AS Hour, Sum([Calls Offered]) AS TotalCalls
FROM yourTable
GROUP BY Hour([Time])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Revolution1200]

Thanks PH

Again provided the ladder to climb out the hole.

A star for you.

Kind Regards

Stuart