Transpose all records of a table into one field

  • Thread starter Thread starter jean
  • Start date Start date
J

jean

Hi

I Have a table containing 2 fields "IDName" and "CustomerName"
The table contains 5 records and it is like this

1 Paul
2 Mike
3 John
4 Peter
5 Bob

and I want to obtain into one field

"Paul, Mike, John, Peter, Bob"

Is it possible to do that ?

thanks
 
Back
Top