How to do running total and subtracting it from budget table??? (1 Viewer)

Hello,

I am trying to create running total using query. For example, I have multiple categories (Basketball, Soccer, etc.) For each sport, we have set budget. In addition, I have multiple expense reports for each category. I am trying to create a running sum where access will total everything by category and subtract it from the main budget file. I've attached my access file and it'll be great if you can show me how to do it. I've been trying to figure this out for the past couple days but due to my limited knowledge in Access, I've been running into circles.

Thank you,

Sounds like you may want to build a SUM query from your main data table, linked to your Budget table

e.g.

Summarize income and expenses by Period, compared to single budget figures held in the Budgets table

ps if you save and upload the database in Access 2003 format (.mdb) a few others will be able to view it and/or assist