Define two number fields such as: Debit, Credit.
Define a calculation field cBal as Debit - Credit.
Define a summary field, sBalance as the Total of cBal with the running total option selected.
Put starting balance in the Debit field of record 1.
Put Entries 1, 2 and 3 in the credit field of subsequent records.
In a list view, table view or portal you can put the Debit, Credit and sBalance fields to set up a basic "ledger" of your transactions. The cBal field need not be placed on any layout.
Thank you so much! Your directions helped a ton! However, now that I am actually doing the running total, I am running into another problem. How can I get the running total to work for separate accounts as well, for example before we worked on the Supplies Account, now I would like to do it for multiple accounts (Travel, Salary, etc.). Would I have to create another layout for each account or would it be able to work in the same layout?
Also, we are trying to track a the budget of different Grants, so along with having a running total for each individual account is there a way to link it so that it give us a running total of the Grant as a whole?
Once again thank you so much for all your help and if you need me to clarify anything just let me know!
Assuming you have a field in your table that identifies the account it belongs to, you have an option in the summary field definition to "restart summary with each sorted group". If you select this option, you can select your account field as the "group by" field. Now you can sort your entries first by account then by date or any other useful order (assumes you have a date field for each transaction record) and you'll see the entries grouped for each account with a running total that starts over for each.
You can also keep your set up as is and just perform a find for a given account. That gives you a view of your transactions with your running total for one account at a time. A portal to this table that displays only one set of account transactions at a time could also be used to segregate your transactions by account.
The running balance worked great for my inventory needs and I'm using my line items table as a ledger. I was beating myself up for a bit til I ran across this post. Thanks PMJ