Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Exclamation Unanswered: Calculate max concurrent connected calls in a halfhour intervals frm strt & end time

    Hi All

    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.

    TEST.xls

    I need to populate columns “E” to “AZ” with the count.

    For example

    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.

    Hyper Dreamz

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    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:
    http://allenbrowne.com/round.html
    http://my.advisor.com/doc/08884

  3. #3
    Join Date
    Aug 2008
    Posts
    2
    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 ?

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Post the SQL for your two queries.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •