var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculate max concurrent connected calls in a halfhour intervals frm strt & end time
Need a little help in calculating the maximum concurrent connected calls in a half hour based on a dump of start time and end time of 4000000 call records in ACCESS.
I have been supplied a raw database in ACCESS.
For your reference I have attached a sample EXCEL file to represent the data I have in ACCESS.
I need to populate columns “E” to “AZ” with the count.
Start Time 05/08/2008 1:57 AM
Stop Time 05/08/2008 2:37 AM
Would have a count in the following intervals
01:30 to 02:00 = 1
02:00 to 02:30 = 1
02:30 to 03:00 = 1
Any help or suggestion would be highly appreciated.
I'd start by rounding the time down to the nearest half hour then use a crosstab query for the counts.
Time rounding info can be found here:
I've tried that, just cant seem to get it to count correctly.
I can get it to count the begining and last interval correctly
The ones in between are the problem.
Any suggestions ?
Post the SQL for your two queries.