Getting a total from a query

L

ljp1215

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
 
M

Marshall Barton

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]
 
Top