J
John Smith
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.
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.