Transpose Data

[Guest]

How do i transpose a list of data in a table, so that the list of data shows
in one text box horizontal with a semicolon between each record. For example

abc
xyz
123

abc;xyz;123

Do i need to build a query for this?

 

[Allen Browne]

Use code like this:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm