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



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: Microsoft Access

See more: clear bits, bits of, milestone payments, how to release a milestone, access payment balance, jan 2014, file payments, period dates, microsoft money, balance payment, payment balance, microsoft access order database, different items, payments milestone, absolute database, access payments, access database payments, payments access database, different period, tabulation, cost access database, construct database, displaying, money access, clear access database

Project ID: #5330554

Awarded to:


This should be straight forward. Send me a db with some sample data and I will revert back immediately

₹1750 INR in 3 days
(75 Reviews)

10 freelancers are bidding on average ₹6812 for this job


Res.Buyer I have gone through your project requirements. I have gone through your file also.. Can I develop it in such a way that a form is shown and then on clicking a button on the form, the program will show the q More

₹7777 INR in 3 days
(464 Reviews)

I have 8 yrs of Exp in VBA,VB6, and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if you want i will also send updated query for same it is possible that in "Released More

₹5555 INR in 3 days
(8 Reviews)

Hello my name is Matt Andrews, I am a Senior Systems admin I believe I can complete your project. Please consider my bid and check out my resume and reviews.

₹6315 INR in 5 days
(2 Reviews)

Aucune proposition n'a encore été fournie.

₹10526 INR in 5 days
(3 Reviews)

Hi I reviewed your requirement to Displaying balance payment for milestone, it is better to build a form to accomplish this. we will have each record (mile stone) will have any number of payments methods describe More

₹10000 INR in 3 days
(1 Review)

i have a good of professional IT experience in the areas of design, development, and implementation of software solutions, i am quite sure that will be able to deliver it on time without compromising with quality

₹1750 INR in 1 day
(0 Reviews)

I did MS Access database for Credit Suisse AG Singapore and Burberry Singapore before single handedly. Your query is not an issue and can be done. I am contactable via m email address kennytbk86

₹6666 INR in 4 days
(0 Reviews)

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

₹11111 INR in 3 days
(0 Reviews)

Expert in ms-access and sqlserver. I have 6+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level.

₹6666 INR in 3 days
(0 Reviews)