Summing TEXT fields

[fredfortsonsr]

Yea, I know, why is it a text field in the first place? I didn't do it, but I must try to fix it. Here it is:
A field (let's call it Weight %) is set to a TEXT type fields and allows the user to enter a value that could have as many as 4 decimal places. This value is entered into a subform of a form. The subform shows scrolling single line records.
I need to sum up the "Weight %" values in the subform and display the total on the form as they are being entered. The value should never equal more than 100%.
I can go into the subform (design mode) and convert the text value with the VAL function but have been unable to sum them. Is there a way to SUM a subset of records based on a TEXT value?
Thanks

 

[KevinM]

Try creating a query and use the VAL function there and then SUM this expression as you can't SUM an Unbound text box in a form.

HTH