running sum for debit-credit in subform

[roshanzarmal]

i have two table


customer(Id,customername)
register (id,date,refno,debit,credit,balance)


table customer ID have 1 to many relationship to register ID

now i want running sum for balance in subform not in report because i have already done it in the database which is attached.

i need RUNNING SUM IN subform looks like IN ATTACH REPORT


asmatroshan@yahoo.com

[ssanfu]

I think this site will help you with the running sum in a query:

RunningSumInQuery.mdb

http://www.rogersaccesslibrary.com/forum/topic279.html