Merge ??

[scorpio_x73]

I have 1 a table named Products and i'm using group by, i have a field named etc witch contains free text and i want to merge all data from that field to 1 filed called all_etc (from all records i mean)

so my table looks like this :

id name code qua etc

1 prod_1 001 1 etc_1
1 prod_1 001 5 etc_2
1 prod_1 001 1 etc_3
1 prod_1 001 1 etc_4
1 prod_1 001 1 etc_5

and my query :

id name code qua etc
Group By Group By Group By Sum ???????????
1 prod_1 001 1 etc_1
1 prod_1 001 5 etc_2
1 prod_1 001 1 etc_3
1 prod_1 001 1 etc_4
1 prod_1 001 1 etc_5

i want to have 1 record like this :

id name code qua etc

1 prod_1 001 9 etc_1etc_2.....


Any ideas ???

Thanks In advane

And Happy new Year

 

[neileg]

This may help:
http://support.microsoft.com/kb/210163/en-us

 

[scorpio_x73]

Hmmm Difficult

This may help:
http://support.microsoft.com/kb/210163/en-us

Something more easy

 

[neileg]

If there was something easier, you wouldn't need the complicated answer!