Access Query for displaying balance payments of each item at different dates

IN PROGRESS
Bids
10
Avg Bid (INR)
6812
Project Budget (INR)
₹1500 - ₹12500

Project Description:
In my database I have certain defined items/milestones, each having a certain amount of money allotted as its cost.

This cost is released/paid in bits and pieces over a period of time.
1. Sometimes the amount is released as an absolute amount,
2. sometimes the released amount is described as a percentage of the allotted cost and
3. sometimes as a percentage of the payment yet to be released.

i.e. say, if the cost of milestone A1 is $10,000

i may release $100 on 1 Jan
then 5% of $10,000 (i.e. $500) on 7 Jan
and then 20% (i.e. 20% of $9400) of whatever is the balance payment
and so on, in no particular order, until the entire cost is paid

My inputs are the milestone number, amount released (either [%] or [absolute] or [% of balance]) and date of release
On any given date, the payments for many milestones can also be released simultaneously (either with the same amounts or differing amounts)

Please tell me how to construct a query such that i get a tabulation sorted by milestone number and then sorted by date and an accompanying column indicating the amount of payment left after that particular date's payment.

for eg. something like below,

Milestone no. Date Amount Balance
A1 1 jan 1000
A1 3 jan 500
A1 7 Jan 200
A2 1 jan 10000
A2 3 jan 4000


If the problem is not clear please ask me, I have also attached a small demo file.

Skills required:
Microsoft Access
Additional Files: running balance.accdb
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


₹ 7777
in 3 days
₹ 1750
in 3 days
₹ 5555
in 3 days
₹ 6315
in 5 days
₹ 10526
in 5 days
₹ 10000
in 3 days
₹ 1750
in 1 days
Hire kennykeng
₹ 6666
in 4 days
₹ 11111
in 3 days
₹ 6666
in 3 days