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?