Sum() everything till date

[Medivh]

Hi. I have created many-to-many relationship as below:

I'd like to create query/ies which will give me table with following columns in result:
Tasks.[Task name] | Tasks.[Money planned] | Resolutions.Number | Resolutions.[Resolutions date] | Changes.[Amount change] | [Money in result]

The problem is the last column which suppose to be:
[Money in result] = Tasks.[Money planned] - "Sum of Changes.[Amount change]" till Resolution.[Resolutions date]"

For example:


I think that one query is not enough, but still can't figure out what that second query should be. Or am I wrong?

Thanks in advance for your help.

[jzwp11]

It sounds like you need a running sum by task number. This is best accomplished with a nested query. I've did a mock-up of your database (I changed the field names slightly by getting rid of the spaces in your fieldnames. Spaces and special characters are not recommended in table and field names). The example database is attached.

[Medivh]

That's exactly what I was trying to achieve. Thank you very much.

[jzwp11]

You're welcome. I'm glad it worked out for you.