combine rows into one

[Guest]

How can I take this field, called size, with several rows in it:

size
1228
1828
2428
3028
3628
4228

And create a field like this with all the rows combined into one?

size1
1248,1848,2448,3048,3648,4248

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.