Totals in a query?

JEB

Registered User.
Local time
Today, 03:22
Joined
Dec 20, 2002
Messages
16
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
 
On the Query Design, on the Totals field, change Group By to Sum.

If the Totals section isn't there, right click on the query building grid and select Totals from the menu.
 

Users who are viewing this thread

Back
Top Bottom