I have data listing the [event], [start] and [end] times.
ie:
[event] [start] [end] [autonumber]
20-1 08:00 09:00 1
20-1r 08:30 09:15 2
21-rt 09:10 10:10 3
22-b 10:00 12:30 4
24-5 10:05 11:00 5
25-a 11:00 11:45 6
event 25-a occures between the start and end times of events 24-5 and 22-b. It could be called a "3rd out event". Event 24-5 occures between the start and end times of events 22-b and 21-rt and could also be called a "3rd out event". Event 20-1r's start time occures between event 20-1 start and end time and would there for be a "2nd out event. Can anyone help me with calculating the sum of "2nd out events" and "3rd out events" and "4th out events"....Etc.....
I would like to generate a report monthly during which there will probably be 400 to 450 events.......
Many Many thanks in advance.....
Shawn
traffas7@prairieinet.net
ie:
[event] [start] [end] [autonumber]
20-1 08:00 09:00 1
20-1r 08:30 09:15 2
21-rt 09:10 10:10 3
22-b 10:00 12:30 4
24-5 10:05 11:00 5
25-a 11:00 11:45 6
event 25-a occures between the start and end times of events 24-5 and 22-b. It could be called a "3rd out event". Event 24-5 occures between the start and end times of events 22-b and 21-rt and could also be called a "3rd out event". Event 20-1r's start time occures between event 20-1 start and end time and would there for be a "2nd out event. Can anyone help me with calculating the sum of "2nd out events" and "3rd out events" and "4th out events"....Etc.....
I would like to generate a report monthly during which there will probably be 400 to 450 events.......
Many Many thanks in advance.....
Shawn
traffas7@prairieinet.net