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