Reverse Pivot multiple Rows into Single Field

[Fattire]

I have 3 items I need to consilate, but I can't lose part of the detail.

Right now 3 lines look like:
INVOICE DESC AMT
123 TAX 5.00
123 FREIGHT 7.00
123 PAPER 9.00

Need it to 1 line and look like:
INVOICE DESC AMT
123 TAX, FREIGHT, PAPER 21.00

Any help would be appreciated.

 

[dhookom]

I'm not sure I would call this a "reverse pivot" but try faq701-4233.

Duane
Hook'D on Access
MS Access MVP