Hi,
I am making a database to manage my banking transactions, similar to ledger.
The table table would contain 6 fields. Serial no, date, detail, deposit, withdrawal and balance.
I have made a form to enter serial number, date, detail, deposit and withdrawal. The report is generated to show the list of transactions.
However, I want the 'balance' to be calculated and seen at end of every transaction. (Kind of running balance, usually seen in a bank passbook or ledger)
For example -
Detail. Withdrawl. Deposit. Balance
B/F. 1000
200. 800
100. 700
150. 850
And so on....
There will only be either deposit or withdrawal in any transaction and not both.
I am having problem in getting the balance field. Can anyone help me.
Thank you.
I am making a database to manage my banking transactions, similar to ledger.
The table table would contain 6 fields. Serial no, date, detail, deposit, withdrawal and balance.
I have made a form to enter serial number, date, detail, deposit and withdrawal. The report is generated to show the list of transactions.
However, I want the 'balance' to be calculated and seen at end of every transaction. (Kind of running balance, usually seen in a bank passbook or ledger)
For example -
Detail. Withdrawl. Deposit. Balance
B/F. 1000
200. 800
100. 700
150. 850
And so on....
There will only be either deposit or withdrawal in any transaction and not both.
I am having problem in getting the balance field. Can anyone help me.
Thank you.