total progressive

[swab]

How can i obtain a total progressive of a colum in access ?
es: my table is ID and Km. i need obtain T_ProKm
ID Km T_ProKm
1 21,50 21,50
2 25,30 46,80
3 26,13 72,93
4 27,37 100,30
5 22,29 122,59
6 173,84 296,43
7 22,34 318,77
8 21,13 339,90
9 227,61 567,51
10 65,66 633,17
11 22,50 655,67
12 600,80 1.256,47

 

[Michel Walsh]

Hi,


T_ProKm: DSUM("km", "tableNameHere", "ID<=" & ID )


Note: it is not required that the ID are continuous, they only need to be
just increasing.

Hoping it may help,
Vanderghast, Access MVP