It can be done with UDF. You pass it all the key's and it returns "SUM" ("Opt1, opt4, opt6, opt11, ..."). Check Re: How To: Group Data and club a field of the group using S Thread #763525


>Hello EveryBody.
>
>i need to group (by upcharges for frames) my frame options. so i end up with 1 record for each different price up-charge. the following works great for this.
>

>sele ;
>      a.* ;
>   from partoptions a ;
>   group by a.option, a.upchoice, a.priceadj
>

>however, i also need in each row to contain all of the different option-codes for that 'group' combined in one field. something simular to the sum(), but, i don't need it added up (it's a character field anyway), i need it combined in a string (like "Opt1, opt4, opt6, opt11, ...").
>
>any ideas other then to scan through the table and collect?
>
>thanks for all your help as always!