Concatinate fields

[chrisgreen]

I have a table with :

ActivityNo, lineNo and comments

ActivityNo and LineNo is the key.

The comment is spead in the table accross the lineNo with the same activityNo. I want to produce a query that has the fields ActivityNo and comments. To do this I need to concatinate all the comments, how do I do this?

 

[Kulguru]

This cannot be done in a single query. Break it into two parts.

In modules, create a function whose parameter is ActivityNo. In the function, write code to fetch comments and concatenate them. The return value of this function will be this long string.

In Queries section, write a select stmt picking up the DISTINCT ActivityNo's and calling the function.

You will get the required result.