I am trying to write a query that will sum the total of payments to invoices and create a new table with these totals.
The fields are: DUEDATE, INVNUM, NAME, PAYMENT
The table contains multiple transactions to one INVNUM (IE an opening balance - payment + credits, etc). I want to sum these payments by invoice and make a new table.
I can't figure out how to get SQL to sum by the INVNUM
Any help would be really appreciated.
Thanks,
Jeb
The fields are: DUEDATE, INVNUM, NAME, PAYMENT
The table contains multiple transactions to one INVNUM (IE an opening balance - payment + credits, etc). I want to sum these payments by invoice and make a new table.
I can't figure out how to get SQL to sum by the INVNUM
Any help would be really appreciated.
Thanks,
Jeb