You can do it with an UDF in a query. See Re: How To: Group Data and club a field of the group using S Message #764483.

>I have a table that contains the following fields (in addition to other fields):
>

>Jobno   Drwno
>6378     1
>6378     2
>6378     3
>6390     1
>6390     2
>etc....
>

>
>Is there an SQL statement that would produce the following fields:
>

>Jobno     Drwstring
>6378      1,2,3
>6390      1,2
>etc....
>

>Can this be done with the 'Group By' command? If so, how?
>
>Thanks in advance for your help!