how can i accumilate the numbers in rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

Mohammed
 
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
 
Back
Top