Reply to thread

Message: [QUOTE="John Smith, post: 4336548"] Hi, Just wanted to check that I'm doing things the right way.......... I need to create a string along the lines of "23,43,78,23" with no comma at the beginning or end of it. The data comes out of a table so i've created a loop to get the data and form the string : StrRecip = "," & objRS("number") & StrRecip This will give me something like : ",42,78,67,2,90" And then I've removed the leading comma : StrRecipRem = replace(StrRecip, ",", "", 1, 1) Is there actually a better way ? Thanks J. [/QUOTE]