Advance Calculation (1 Viewer)

[syedadnan]

I am looking for advance calculation suppose

i have a Client table and have a CID as client ID now if i am recieving payments against Client ID and making Purchase again Client ID so the system to calculate previous advance first for e.g

give advance to CID 360 is 2000
now purchase stuff from CID 360 of 550
so i want running balance of advance forr the CID 360 if i make any further transaction agaist the same CID

 

[Uncle Gizmo]

Quick scan of your question and I'm getting nothing, I do not grasp the essence of the problem. However you do mention running sum so I thought this might be something you would want to look at:-

http://www.rogersaccesslibrary.com/...l?SID=1ad20d6294bfb7bf5d764e964fca75638888889