AnsweredAssumed Answered

How can I create a previous balance field I can use to calculate a new balance?

Question asked by bwbono on May 23, 2010
Latest reply on May 23, 2010 by comment_1

Title

How can I create a previous balance field I can use to calculate a new balance?

Post

I am using 2 tables in a database...one named BANKBOOK, which holds all transactions and another table called STATEMENTS, which allows for a portal of BANKBOOK showing only the transactions by related statement number. For example, statement number 45 has 6 transactions and shows a Statement summary of $150. I would like to be able to also show the previous statement (44)  balance so I can use it to calculate the currently viewed statement. So, if statement 44 had a balance of $50, I could then see that on statement 45 (with it's statement summary of $150) that I actually have a true balance of $200.

 

I just cannot seem to make this happen correctly. I hope I have explained the problem clearly enough.

 

My main goal in this is to be able to look through each STATEMENT and see exactly where I stand at any point in time, to control.

Outcomes