Concat different rows column into single row field

[troppfigo]

Suppose u have a view made out of some tables, which results in a table
like givin this present output

see down.. data in TABLES

PRESENT OUTPUT

ID Name Dependents day
712 Manish Sudha Monday
712 Manish Sudha Friday
712 Manish Sudha Sunday


REQUIRED OUTPUT

ID Name Dependents day
712 Manish Sudha Monday,Friday,Sunday


Here in the output required (ID is the primary key), I want all days to
be printed in the same row concatenated by ,

Can you help me?please.
Can you post some examples.

 

[Duane Hookom]

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
should work for you.