Hi,
I am currently in the process of compiling a new access database to calulate outbound abandon rates for an outbound dialler with Raw Data exported directly from a central database, not through the provided software from the dialler (which is hurrendously resouce intensive on the client and server end machines)
My current control source for a textbox:
Code:
=Sum(([Abandoned Calls]-([Abandoned Calls]*([Answering Machine]/([Third Party Contacts]+[Right Party Contacts]+[Answering Machine]))))/([Third Party Contacts]+[Right Party Contacts]))
What i want to do is input the value of a text box called "New_Abandoned" into the latter part of the Control Source code as such:
Code:
=Sum(([Abandoned Calls]-([Abandoned Calls]*([Answering Machine]/([Third Party Contacts]+[Right Party Contacts]+[Answering Machine]))))/([Third Party Contacts]+[Right Party Contacts]+[New_Abandoned]))
This issue i get with this is that it returns:
The Microsoft Office Access database engine does not recognise '[New_Abandoned]' as a valid field name or expression.
I have also attempted to add back in the formula which is within the textbox into the control source as:
Code:
=Sum(([Abandoned Calls]-([Abandoned Calls]*([Answering Machine]/([Third Party Contacts]+[Right Party Contacts]+[Answering Machine]))))/([Third Party Contacts]+[Right Party Contacts]+([Abandoned Calls]-([Abandoned Calls]*([Answering Machine]/([Third Party Contacts]+[Right Party Contacts]+[Answering Machine]))))))
But the Field then just returns as '#Error'
Please can someone help with the correct method for pulling the value of another textbox in a Control Source method?