convert columns to rows?

J

JamesSF

i have a small query with 1 column of data of varying length

i want to conver them to a single row , comma delimited

is there a function that i can use to convert the items from 1 column to 1
row?

thanks
JamesSF
 
G

Guest

not in access that i am aware of.
excel has the paste special transpose that will do that
but is limited to 255 columns.
 
A

Andi Mayer

i have a small query with 1 column of data of varying length

i want to conver them to a single row , comma delimited

is there a function that i can use to convert the items from 1 column to 1
row?
Click to expand...
i am not aware of a function I do it this way (airCode without error
check)

dim rs as dao.recordset
dim tmp as string
currentdb.openrecordset(mySQL)
while not rs.eof
tmp=tmp &"," &rs.fields(0)
rs.movenext
wend

tmp=mid(tmp,2)

now do what you like with the tmp-String
 
Top