how can i accumilate the numbers in rows

M

Mohammed Khider

Hi,

How can I accumilate the two numbers in the same row like the same way in
Microsoft Exel.

Mohammed
 
M

Michel Walsh

Hi,


You need a field that define the order. A dateTimeStamp (for a transaction)
can do, without duplication:


SELECT a.DateTimeStamp, LAST(a.f1), LAST(a.f2), SUM(b.f1), SUM(b.f2)
FROM myTable As a INNER JOIN myTable As b
ON a.DateTimeStamp >= b.DateTimeStamp
GROUP BY a.DateTimeStamp



The LAST(a.FieldName) is the value, and SUM(b.FieldName) as running sum.



Hoping it may help,
Vanderghast, Access MVP
 
Top