Hi,
you mean with a query?
----------------------
SELECT a.DateTimeStamp, LAST(a.Amount), SUM(b.Amount)
FROM myTable As a INNER JOIN myTable As b
ON a.DateTimeStamp >= b.DateTimeStamp
GROUP BY a.DateTimeStamp
ORDER BY a.DateTimeStamp
---------------------
or
---------------------
SELECT a.DateTimeStamp,
a.Amount,
(SELECT SUM(b.Amount)
FROM myTable As b
WHERE a.DateTimeStamp >= b.DateTimeStamp)
FROM myTable As a
ORDER BY a.DateTimeStamp
--------------------
Hoping it may help,
Vanderghast, Access MVP