SELECT InvoiceNb, SUM (InvoiceAmount) FROM Invoices GROUP BY InvoiceNb

HTH

>I have a SQL SELECT that returns all detail records for an invoice
>by invoice #.
>
>I want to rill them up so that I get one record representing the totals
>for each invoice.