Getting a total from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several accounts with different $ amounts made to each account
throughout the month. How do I sum these totals so that I have 1 record for
each account with the total $.

1234567 $100
1234567 $200
1234567 $50.00
1234567 $75.00
 
ljp1215 said:
I have several accounts with different $ amounts made to each account
throughout the month. How do I sum these totals so that I have 1 record for
each account with the total $.

1234567 $100
1234567 $200
1234567 $50.00
1234567 $75.00
Click to expand...

SELECT AccountNum, Sum(Amount) As MonthAmt
FROM thetable
GROUP BY AccountNum
WHERE DatePaid Between [start date] And [end date]
 
Back
Top