How To Do Running Total And Subtracting It From Budget Table?

[latestgood]

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.

[alansidman]

Look at the attached. I created a second query based upon the first query. I changed the first query to an aggregate query that summed expenses by category. Then used that query as the record source for the second query. Look at the designs.

[latestgood]

alansidman,

Thank you!!!