Concatenate Function

[DeRochier]

A loooong time ago, someone provided a great concatenate function here on the forum. I'm hoping someone can point me to it.

The function would take a field in a record set and concatenate them, separating the record values with a comma.

For example, if the table contained:
Yellow
Orange
Red
Purple

The concatenate function would return: Yellow, Orange, Red, Purple

Any assistance would be greatly appreciated.

 

[sxschech]

Was it this?

http://allenbrowne.com/func-concat.html

 

[DeRochier]

That's it! Thank you!

 

[dhookom]

There is also one here faq701-4233.


Duane
Hook'D on Access
MS Access MVP