wailingrecluse
Registered User.
- Local time
- Today, 23:40
- Joined
- Feb 10, 2009
- Messages
- 50
Hi guys, I hope someone can help with this, it's proving to be quite complex (either that or I'm making it harder than it has to be)
What I'm trying to do is:
* Find the number of calls within the same date that have the same phone number. These will have different Call IDs.
* When I have 2 (or more, but let's say 2 to keep this simple) calls with different ID's but the same phone number, I want to determine which is call 1 and which is call 2. I want to check the start time of both calls and call the earliest one "Call1" and the later one "Call2".
* Now that I have this, I want to check if the start time of "Call2" is earlier than the end time of "Call1".
The reason is I'm trying to measure the volume of repeat callers. However, someone may have legitimate reasons for calling more than once in which case the start time of the second call would be later than the end time of the first call. What I'm trying to measure is people who are calling a second time before the first call is ended.
I know this may seem impossible to do, but it's a call-back system so the calls are actually booked call-backs.
How do I go about this in either VBA or in Queries?
Thanks!
What I'm trying to do is:
* Find the number of calls within the same date that have the same phone number. These will have different Call IDs.
* When I have 2 (or more, but let's say 2 to keep this simple) calls with different ID's but the same phone number, I want to determine which is call 1 and which is call 2. I want to check the start time of both calls and call the earliest one "Call1" and the later one "Call2".
* Now that I have this, I want to check if the start time of "Call2" is earlier than the end time of "Call1".
The reason is I'm trying to measure the volume of repeat callers. However, someone may have legitimate reasons for calling more than once in which case the start time of the second call would be later than the end time of the first call. What I'm trying to measure is people who are calling a second time before the first call is ended.
I know this may seem impossible to do, but it's a call-back system so the calls are actually booked call-backs.
How do I go about this in either VBA or in Queries?
Thanks!
