What I meant is if I have 5 column in a grid or table :
column #1 -- Date
Column #2 -- Description
Column #3 -- income
Column #4 -- Expense
Column #5 -- Balance
To count the balance field, usually I do like this :
Select (mytable)
Scan
mrec=RECNO()
SELECT SUM(out-in) FROM (mytable) WHERE RECNO()
mbalance=total+in-out
REPLACE balance WITH mbalance
ENDSCAN
THIS Procedure take to long, specially if I edited a record in the middle, so I have to start all over again.
Hope you understand what I'm trying to explain....
Thanks a lot
Senna Dwipayana
Being good is better
Being better is a bless