Report by parameter

[sthapa]

Hi all

I have a basic database that stores call time, duration and date.

Im trying to run a report that only shows me ;
Numbers of calls per hour
Total Duration per hour

All grouped by the Date, So for exmaple, i want to know how many calls came in on the 7th Apr between 08:00:00 and 09:00:00 and what was the total duration

Is there an easy way to do this

Thanks in advance

 

[dopedealer]

you have not provided enough information to give you a definative answer, please provide your table structure and any queries you have created before someone can begin to help you.
chris

 

[sthapa]

All there is, is a table with 3 fields, Date, Time, and Duration
No queries have been created.

 

[dopedealer]

Is the Start Time and End Time automatically stored? Also is it stored in just the one field?
Chris

 

[sthapa]

All the table comes into the table via a connection a pbx switch.
The end time is not recorded, just when the call comes in, and how long it lasts for.

 

[dopedealer]

There are many ways to achieve what you want done, one way to go is to make a chooser form so to speak and put in 3 combo boxes, one with date , the other two with time(from and to). then make a query based on your table and in the criteria for the fields set the Date criteria to Forms!NameOfFormWithThe3Combos!Combo1.value (Date) For the From Field Forms!NameOfFormWithThe3Combos!Combo2.value(From Time) for the to Field Forms!NameOfFormWithThe3Combos!Combo3.value and make an extra field in a table or query and call it duration, for duration you will have to write a formula, the grouping can be done in the report which you will create based on this query.
That should get you started.
Chris

 

[sthapa]

thanks for your help Chris