| ">Homepage |
| IT Services |
| ">Consulting |
| " >Training |
| ">Get help now |
| ">Application Development |
| ">Support and Downloads |
| About us |
| ">Contact information |
| Applications |
| ">MS Access |
| ">MS Excel |
| Coding and Macros |
| ">Excel VBA |
Creating Cumulative (Running) Sum - SQL
One of the most simple ways to have the query make an additional running sum to a field. This requires the table to have distinct values only on a keyfield (in this case Mth)
SELECT Totals2.Product, Totals2.Mth, Totals2.Qty, (SELECT SUM(Qty) FROM Tbl_Totals Totals1 where Totals1.Mth <= Totals2.Mth) AS RunningSum FROM Tbl_Totals AS Totals2 ORDER BY Totals2.Mth;
Result:
Last modified on August 19 2015
