How to calculate sum of all value in a text field

[Henry]

Hi there, if i want to calculate a total of a series of value in a text field, how can i do it. Just like if a text field contain ( 2 5 7 2) then the result will become 16. The value are normally in seperate line. Like

2

5

7

2

Regards,

Henry

[LiveOak]

If the values are "normally" on separate lines, what other ways may they appear? ("normally" in database design isn't nearly as useful as "always")

-bd

[-Queue-]

Here's a sample file, courtesy of the magic of DJ, if, in fact, 'normally' becomes 'always'.

Normally.zip

[Henry]

That's what i want.

Thanks