how do I create a running balance in a query

M

Michel Walsh

Hi,


If you run the Amount over a DateTimeStamp value:


SELECT a.Amount, a.DateTimeStamp, SUM(b.Amount) As running
FROM myTable As a INNER JOIN myTable As b
ON a.DateTimeStamp >= b.DateTimeStamp
GROUP BY a.Amount, a.DateTimeStamp



Hoping it may help,
Vanderghast, Access MVP
 
Top