The COLUMNSTOTEXT calculation function concatenates the contents of the columns in a table or row object to one text in a column. Separator characters can be specified to be inserted between the individual parts of text.

The attached zip file contains a working example, the connection files and a sample access database(training.mdb) that is used with the application.

 The link to the arcplan application Designer online help for this function is here:

COLUMNSTOTEXT

Here is the link to the online Helpfiles Index page:

And the attachment:

COLUMNSTOTEXT.zip