convert columns to rows?

  • Thread starter Thread starter JamesSF
  • Start date Start date
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
 
not in access that i am aware of.
excel has the paste special transpose that will do that
but is limited to 255 columns.
 
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
 
Back
Top