Dealing with Old Balance

[Altaful Haq]

Hi I have a form with the following fields i need some help.

CustomerName PurchaseItem UnitPrice Quantity Balance OldBalance TotalBalance PaidBalance RemainingBalance


xyz--------------- Pen----------- 5---------2------- 10------- 0---------- 10------------ 5--------------- 5
abc--------------- Pen----------- 5-------- 3------- 15------- 0---------- 15------------ 8--------------- 7
xyz--------------- Book---------- 10------- 1-------- 10------ 5 ---------15----------- 15-------------- 0
abc--------------- Ink------------ 2-------- 3-------- 6------- 7 ---------13----------- 13-------------- 0
I need to bring the RemainingBalance "5" of the customer "xyz" into the OldBalance in his next record. Help me Brothers.

[June7]

Showing running sum in query or on form is not easy. However, textboxes on report have a RunningSum property.

Otherwise, review http://support.microsoft.com/kb/290136

[Altaful Haq]

Thanks....