aqif
Registered User.
- Local time
- Today, 03:19
- Joined
- Jul 9, 2001
- Messages
- 158
Hi
I am trying to work out a query but dont seem to find the suitable logic. Lets look at my exiting output from query
Select Or_Date, Sum(Or_Amount) As Sum_Amount from MyTable group by Or_Date;
Or_Date Sum_Amount
---------------------------
1-1-2001 25
2-1-2001 20
3-1-2001 45
and so on......now I want the cummulative sum in the next colum like accountants do in thier accounts:
Or_Date Sum_Amount Cummulative_Sum
---------------------------------------------
1-1-2001 25 25
2-1-2001 20 45
3-1-2001 45 90
Thanx in advance
Cheers!
Aqif
I am trying to work out a query but dont seem to find the suitable logic. Lets look at my exiting output from query
Select Or_Date, Sum(Or_Amount) As Sum_Amount from MyTable group by Or_Date;
Or_Date Sum_Amount
---------------------------
1-1-2001 25
2-1-2001 20
3-1-2001 45
and so on......now I want the cummulative sum in the next colum like accountants do in thier accounts:
Or_Date Sum_Amount Cummulative_Sum
---------------------------------------------
1-1-2001 25 25
2-1-2001 20 45
3-1-2001 45 90
Thanx in advance
Cheers!
Aqif