progressive sum query

B

balu

dear brothers / sisters.

im looking for the query like this for my accounting database
exactly my need is like an bank account deposits
in which deposits will be individual(groupby) ,but the sum of the deposits
will be like the (groupby) of progrssive sum of deposits .
for eg,
TABLE 1
account holder
account
address

TABLE 2
accountnumber
deposit
withdrawl

query:
groupby(accountnumber,accountholder,deposit,withdrawl),progressivesum(groupby(deposit)),progressivesum(groupby(withdrawl)),and finally accountbalence.
sorry for im not being clear.
it looks like [deposit] 100 ,200,300
[withdrawl] 50,0,0
[progressivesum deposit] 100 ,300 , 600
[progressvesum withdrawl] 50,50,50
kindly help
withregards.
 
Top