Need help with a running balance

[Ray001]

I need help..I created a database that tracks expenses and revenues for diff. accounts with categories. However, I am stuck in maintaining a running balance for each account's category. Not sure how to write a formula for calculating this. Fairly new to this since I always been using excel. here is what I have created so far:

Expense layout with dropdown exp accounts and categories.

A File containing the accounts numbers, balances for each category with subbalance and ending balance and is link to the Expeses layout but cannot figure out how to make the calculations. I have made many databases and used the

subsummary field to run a balance but not a running balance..

Thank you in advance...

Ray

[The Shadow]

Welcome to fmforums, Ray.

When creating a summary field that totals another field, there is a checkbox to make it be a "running total".

Hope that helps.