Adding all the rows in a fied together!

[tbow50]

I am trying to add all the entries in a single field table together and display the result in a text box. And also is there a way of accessing certain rows?

[Clunietp]

you want the SUM of the rows, or you want to concatenate the text/string values to form a single value of strings?

if you want the SUM, you can do it via a single SQL statement, but if you want to concatentate, you'll need to do it programmatically (looping & concatenating with a recordset)