Finding records with overlapping times

C

csingram

My table has an Case ID, date, start time and stop time. I need to be able
count the records with overlapping times. This is an OR utilization
application and we want to know how many cases we have going on at the same
time. For example: Case 1 Start time 11:00, Stop time 12:58; Case 2 Start
time 11:42, Stop time 12:28; Case 3 Start time 11:55, Stop time 12:10; Case 4
STart time 12:12 Stop time 13:35. Cases 1, 2 and 4 would be concurrent. But
since Case 3 was over before Case 4 started, it would not be counted. I know
very little VBA, but would really appreciate help with this. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to build subquery on aggregate query 0
Group by Non-blank Distinct Values 5
Counting Concurrent timed events 8
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Convert string to military time string 14
View Null Results in Query 1
Formula for adding time 2
Grouping/Deleting Dates/Times (HELP ANYONE!) 2

Top