Adding numbers in a text field - Possible?

[Dimwhit]

I've got a large text field that I'm using to enter numbers, like this:

4

5

5

2

6

I'm using a text field because it's the only one that seems to let me enter multiple numbers like this. However, it doesn't seem possible to do a SUM on all the numbers in that single text field. Is there a different field type I should be using for input? Or is there a different function that will add the numbers up for me?

[dwins]

Evaluate ( Substitute ( fieldname ; ¶ ; "+" ) )

Edited January 26, 2007 by Guest

[Dimwhit]

That seemed to do it. Thanks!