>I think he wants a "running total" - the value gets accumulated from one record to the next.
>
Yes Hilmar,
blnc = blnc+debit-credit
and
update AccTran;
set Balance = blnc+debit-credit;
where Code = ThisForm.Code.Value
don't works for Khubaib.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst