How do i gennerate a field containing the cummulative in a query?

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

Guest

I want to create a query that calculates a cummulatinve sum of values that
are ordered descending.

I.e
NAME VALUE CSUM
aaa 100 100
bbb 90 190
ccc 50 240
ddd 20 260

Any ideas?

Any help would be much appreciated
 
SELECT a.name, LAST(a.value), SUM(b.value)
FROM myTable As a INNER JOIN myTable As b
ON a.name >= b.name
GROUP BY a.name



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top