Easy question - Sum fields in table

[crystalfun]

I have an AP table showing all entries in database. If an invoice was charged to 10 different companies I see the invoice number 10 times with 10 different $$ amounts.

What's the command to add up the dollar amounts so that I see one invoice number and one total dollar amount?

 

[DrewConn]

Try this:

Select inv_nbr, sum(Amt)
from myTable
group by inv_nbr

Hope this helps

 

[fluteplr]

select invoiceno, sum(amount) from mytable group by invoiceno order by invoiceno