M
Marcelo Henderson via AccessMonster.com
I have table "Index":
indexID;
IndexDt
Previous
Today
Accumulated
ID| Date |Previous| Today |Acumulated
1 | 10/08/07 | 0 | 2 | 2
2 | 11/08/07 | 2 | 2 | 4
3 | 12/08/07 | 4 | 3 | 12
4 | 13/08/07 | 12 | 2 | 24
5 | 14/08/07 | 24 | 2 | 48
How can I effect the calculations:
Previous is Yesterday acumulated
indexID;
IndexDt
Previous
Today
Accumulated
ID| Date |Previous| Today |Acumulated
1 | 10/08/07 | 0 | 2 | 2
2 | 11/08/07 | 2 | 2 | 4
3 | 12/08/07 | 4 | 3 | 12
4 | 13/08/07 | 12 | 2 | 24
5 | 14/08/07 | 24 | 2 | 48
How can I effect the calculations:
Previous is Yesterday acumulated