Showing running total for each month (1 Viewer)

[umair434]

Hi all,

I have been trying to figure this out for a while.

I have a list of products that have a loan payment associated to them. To cover these loans, we have incoming revenue for each product at different dates.

The incoming revenue is a field of running sum of revenue for each product.

Desired output:

I want to how how much % of loan (jn total; for all products) is paid in October, november and december and as such (as cumulative). i.e. total of 40% in Oct, 70% in Nov and 100% by Dec etc.

I am attaching the database, with sample data.

Any suggesstions would be much appreciated.

Thanks,

 

[jdraw]

see http://www.access-programmers.co.uk/forums/showthread.php?t=249532
or similar request