Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1516 | Replies: 0
•
•
Join Date: Jun 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Running Balance in Filemaker Pro 8? I have been trying to get filemaker to give running balances but its impossible. Lets say I have an accoount with the following transactions:
OpenBal Deposit Withdrawals ClosingBal Date
Rec1 0 10000 0 10000 30 Sept 2005
Rec2 10000 0 5000 5000 31 Oct 2005
Rec3 5000 2000 0 7000 30 Nov 2005
Rec4 7000 0 0 7000 31 Dec 2005
Rec5 7000 3000 1000 8000 31 Jan 2006
Clearly the closing balance for the end of the month becomes the opening balance for the beginning of the next month. But Filemaker cannot take the value from record 1 closing balance and place it into record two opening balance. How do I get it to do this without a self join which ends up crashing the programme.
OpenBal Deposit Withdrawals ClosingBal Date
Rec1 0 10000 0 10000 30 Sept 2005
Rec2 10000 0 5000 5000 31 Oct 2005
Rec3 5000 2000 0 7000 30 Nov 2005
Rec4 7000 0 0 7000 31 Dec 2005
Rec5 7000 3000 1000 8000 31 Jan 2006
Clearly the closing balance for the end of the month becomes the opening balance for the beginning of the next month. But Filemaker cannot take the value from record 1 closing balance and place it into record two opening balance. How do I get it to do this without a self join which ends up crashing the programme.
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode