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

[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

 

[Michel Walsh]

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