Looping records

[arshesander]

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?

[leinad31]

http://www.vbforums.com/showthread.p...unning+balance

[Fazi]

I used MS Access, while the program graws the execution time greatly increases. so i just moved to MSSQL and now feel very comfortable.

Consider moving to MSSQL

[Fazi]

You have created the same thread twice.

[BillGeek]

If you only want to display the Balance (credit - debit) then just change your SQL query a bit:

SELECT credit - debit FROM tablename

[leinad31]

If you only want to display the Balance (credit - debit) then just change your SQL query a bit:

SELECT credit - debit FROM tablename

Its not a per record calculation... its a running balance, previous balance is adjusted with current debit and credit to get current balance.

[BillGeek]

According to the original question asked, it seemed like the aim was to display the Credit, Debit and (Credit - Debit)... Am I missing something?

[leinad31]

According to the original question asked, it seemed like the aim was to display the Credit, Debit and (Credit - Debit)... Am I missing something?

Your misinterpreting the data, probably 'cause you looked at only the first 2 lines.

Credit 100 to 0 --- Balance 100
Debit 50 from 100 --- Balance 50
Credit 25 to 50 --- Balance 75
Debit 75 from 75 --- Balance 0

[BillGeek]

My bad... I wasn't looking.

[Hack]

Duplicate threads merged.

Please do not create multiple threads for the same question.