How to create accumulated expense?

[latestgood]

Hello,



I have a question. I have a multiple categories (eg. Basketball, Soccer, Football). Then, I have multiple expenses that falls under each category. There may be multiple expenses for category one. Let's say that I have a budget for basketball at $5000. I want to set up a query where I want to deduct my expenses from selected category. However, access deducts from the original budget. For example, access deducts $1000-23 for expense one. But for expense two, access deducts from original amount of $1000. I want to set up a query where expense 2 will deduct from leftover balance. Is this possible with Form?

Thank you,

[June7]

You want to do a running sum (balance)? Google: Access running sum
Here is one http://office.microsoft.com/en-us/ac...005187388.aspx