total progressive

  • Thread starter Thread starter swab
  • Start date Start date
S

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