How to query for this output?

[seemi143]

i have a table invoicedetail.



data is

invoiceno partnumber qty docno

1-------- a----------3 ----11
1 --------a--------- 1---- 12
1 --------a--------- 2----- 9
2 --------b--------- 5 -----27
2 --------b--------- 4----- 19



now i want output


invoiceno partnumber qty docno

1------------ a------- 6 ----11 , 12 , 9

2------------ b------- 9----- 27 , 19


can any body give me query for this output?
thanks

[June7]

This will require VBA. Review: http://allenbrowne.com/func-concat.html