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?
Printable View
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?
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)