Recent content by the_rookie

Neither of these feilds is the PK. (its something else)there will be a maximum of 7-8 records that will be concatnated into one.

true, but i want all these records to be concatnated into one Fileld1 Field2 Feild 3 1 a x 1 b y 1 c z should become Fileld1 Field2 Feild 3 1 a,b,c x,y,z

actually i want to concatnate multiple records, not fields... Ex:ID, Field1, Field2,... 1 , x , y,... 1, z , m,... 1, n , h,... converted to -- ID, Field2, 1 , x, z, n, Can someone tell me how i can do this? thanks

Hi, I have a similar problem, and the given solution seems to work. But I'm new to adding VBA stuff to access, so can someone teach m,e how to add a VBA script to a access database? thanks!