list assistance.

[Guest]

I need help with this one. I am not much of a programmer.

I have a list with two columns. like the example below.
Column 1 / Column 2
abc / 151
abc / 152
abc / 153
bbb / 152
ccc / 111
ccc / 121

I need to get the following results.
If Column 1 has only one record, display that record like this
bbb / 152 The "/" is a new column or field.

If Column 1 has more than record, display that record like this
abc / 151, 152, 153

So my new list (preferably a table or make table query) looks like this
Column 1 / Column 2
abc / 151, 152, 153
bbb / 152
ccc / 111, 121

I am out of my league here. Please help.

 

[Duane Hookom]

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