Transpose all records of a table into one field

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning a 3 column flat file into a "3D" Table 2
Change values of filtered records 2
SELECT DISTINCT only on some fields but display all fields (AC 200 3
Turning Data into a Table 1
how to transpose multiple columns into rows? 7
How to Edit Records when some fields are "Many to 1" relationship 2
grouping multiple records on joined table 2
Restrict a Table number of Records 5

Top