Solved Data Arrangement in table fields (1 Viewer)

[jaikaoliver]

Hello great team
I'm looking for away using VB to pull 10 records of client contact numbers from a field of a table to another table but be arranged as a record while each contact being separated by a comma in the destination table
Any way out please
Below are sample table pictures of my expectations

 

[Gasman]

Just concatenate each with a "," and remove the last ","

 

[Isaac]

theDBguy's Access Blog: SimpleCSV()