Search the Community
Showing results for tags 'balance'.
I am trying to create a log sheet of sorts that shows the users transaction history. I have the table (as below) showing different transactions debit for income and credit for expenses but I want the balance column to show how the balance is increasing or decreasing as the transactions are coming in. ie User makes a deposit of 1000 and the balance also displays 1000, but next line he has an expense in the Credit column of 100 so balance should reflect 900. The table houses multiple users as seen above so that another users credit or debit doesn't influence other users balances.
RE: I've got a question. I used the code and have a bit of an issue. What if there's more than 1 page? It will not calculate the balance since it's a new page and the last balance is not recorded on anyway so the it will not run. Does anyone have any ideas how it can be done? Thank you!