Running Balance in a DATASHHET

E

Evan Camilleri

is it possible to do a Running Balance in a DATASHHET?

I know how to do it in a report, but in a datasheet?

Evan
 
M

Michel Walsh

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
 
Top