How to sum a sum...

[tonye53]

Hi All,
I have a table that has mulitple rows for each date with an amount. I want to sum the amount by date, then have a running total of that sum:

Current table:

Date Amount
4/25 10
4/25 20
4/26 15
4/26 30

The output I want would be:

Date Amt Total
4/25 30 30
4/26 45 75

Thanks in advance!!

 

[Brianwarnock]

Lookup runningsum on ACCESS help

Brian

 

[tonye53]

Brian, the access help tells how to sum, I am doing this programatically and need to do a sum of the original sum. The access help does not mention this and is related to the design wizard, but thanks anyway...

 

[tonye53]

Okay, I figured this out (finally). Here is what worked in acccess for me:

SELECT a2.TDate, a2.Amt, (select sum(amt) as total
from tblDailySummary
WHERE TDate <=a2.TDate ) AS Total
FROM tblDailySummary AS a2;