put items from table into a string

[p0welly]

This may seem like a silly one but i cant think where to start,

I have a table called tblCustomers and one of the columns is Mobile containing their mobile phone numbers.

I need to read through the list of numbers and add each one to a comma seperated string, such as:

"44771012345,44771023456"

any pointers would be appreciated

Thanks

 

[EMP]

See the code by Jon K in this thread:

E-Mailing list of recipients
http://www.access-programmers.co.uk/forums/showthread.php?t=103419

^

 

[p0welly]

that perfect thanks, and thaks to Jon K aswell