VBA Concatinate feild values grouped by another field
Posted on 2006-11-15
I've got ProjectCode and CustomerName fields with a one to many relationship of any number... could be 1 to 2 or 1 to 20!
I need to concatinate the CustomerName field with commers in between and i don't think it can be done with SQL but perhaps with a loop statement in VBA?
A1 Name1, Name2, Name3
Hope someone can help.