invalid string error in calculated field access form.

[mike02]

Hey,
I am trying to have a calculated field in my access form. I am inputing it in the control source, I am getting the error:
Expression you have entered has an invalid string.



Im confused, since this expression worked in my query, for another report.

= ((1+[F2T1])*(1+[F2T2])*(1+[F2T3])*(1+[F2T4])*(1+[F2T5])*(1+[F2T6])*(1+[F2T7])*(1+[F2T8])*(1+[F2T9])"(1+[F2T10])*(1+[F2T11])*(1+[F2T12]))-1

Thanks,

[pbaldy]

My guess would be the " rather than * between 9 and 10.

[mike02]

thanks, missed that.

[pbaldy]

No problem.