Q: Calculate strings

AlphaG; KITFAM@peg.apc.org wrote: 
I have tried the following formulaes without success: 
(a) In the Total paid to date text box: 
Sum(txtPaidtoDate1 + txtPaidtoDate2 + PaidtoDate3 + PaidtoDate4 + 
PaidtoDate5)

A: 
your txtPaidtoDate1 etc is just a string value so you cannot add them. 
Just make a value of it and it will go alright:



txtTotalPaid = Cstr(Val(txtPaidtoDate1) + Val(txtPaidtoDate2))

Return