Aggregate versus lineitem report

How do you get a report that lists items and then produces a sum at the 
end.  Like this:

name     date   amount1   amount2
name     date   amount1   amount2
name     date   amount1   amount2

totals             sum(amount1)   sum(amount2)

The sql command I am using now is
 SELECT SUM(Tcode.T_amount) Fees,        SUM(Tcharges.T_discount) Discount,        Tcode.T_prov Provider   FROM
"C:\zz\Tcode.DAT"Tcode        INNER JOIN "C:\zz\Tcharges.DAT" Tcharges                ON Tcode.T_acctnum =
Tcharges.T_acctnum              AND Tcode.T_link = Tcharges.T_link  WHERE (((Tcode.T_posted BETWEEN "01/01/2004" AND
"01/31/2004")   AND (Tcode.T_tcode < 30000)))
 
GROUP BY Provider

And that shows a list of amounts, for each provider, but I want to be 
able to show all the line items that added up to those totals.  (I didnt 
include the group by provider issue in my question because that is nice 
but not necessary- I can always just do one provider at a time with a 
clause like "WHERE provider = 1")

TIA
Jerry