Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"csingram" <email@example.com> wrote in message
> 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
> 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.
> since Case 3 was over before Case 4 started, it would not be counted. I
> very little VBA, but would really appreciate help with this. Thanks.