im using ms access as backend database;
this are my records;
Debit ---> Credit ---> Balance
============================
0.00 ---> 100.00 ---> 0.00
50.00 ---> 0.00 ---> 0.00
0.00 ---> 25.00 ---> 0.00
75.00 ---> 0.00 ---> 0.00
now using Do while | Loop statement it goes like this;
Debit Credit Balance
===========================
0.00 100.00 100.00
50.00 0.00 50.00
0.00 25.00 75.00
75.00 0.00 0.00
Balance = Credit - Debit
is there an easiest way to do this w/o looping the records? because if it is thousand of records? it takes me time before it display the results
kindly help me pls?
