mrma...@gmail.com wrote :
Try:
SELECT DailyNewAccounts.yyyymmdd, DailyNewAccounts.CountOfid,
(Select Sum(CountOfid) From DailyNewAccounts as RT
Where RT.yyyymmdd <=DailyNewAccounts.yyyymmdd) AS cumulative
FROM DailyNewAccounts
ORDER BY DailyNewAccounts.yyyymmdd;
Rdub