J
Jay974 via AccessMonster.com
I created a database to be used by our sales teams for outbound calling (not
cold calling). It has been in use for about a week or so now and the MI
requirements I were given have changed slightly (as they do)
What I need to be able to do is provide call MI for the outcome of each call
split by the attempts it took.
For example, if I try to call a number the first time and there is no answer
and the second attempt got me through to the right party, I need to be able
to show that on my first attempt calls, I got one no answer and on my second
attempt calls, I got one right party.
Unfortunately, I can’t think how I write the query to display this. In an
attempt at a short cut, I am going to change the input form which will
calculate how many attempts there have been to that customer on that date
(based on customer ID number which is unique). This will be the default value
on a hidden field which will be captured in the new int field I put on my
table, but is there any way I can run this retrospectively for the couple of
thousand records I already have?
Many thanks for your assistance
cold calling). It has been in use for about a week or so now and the MI
requirements I were given have changed slightly (as they do)
What I need to be able to do is provide call MI for the outcome of each call
split by the attempts it took.
For example, if I try to call a number the first time and there is no answer
and the second attempt got me through to the right party, I need to be able
to show that on my first attempt calls, I got one no answer and on my second
attempt calls, I got one right party.
Unfortunately, I can’t think how I write the query to display this. In an
attempt at a short cut, I am going to change the input form which will
calculate how many attempts there have been to that customer on that date
(based on customer ID number which is unique). This will be the default value
on a hidden field which will be captured in the new int field I put on my
table, but is there any way I can run this retrospectively for the couple of
thousand records I already have?
Many thanks for your assistance