Recent content by Yasir

Sorry about the delay. This is for when it takes 9 years to reach 100%, if it's 8 years I would remove Thanks for your help bro!

Okay... I have a table that has the disbursement profile for, let's say, a loan. You want to disburse 100,000$ over 10 years and this shows how they spread out. This table just has the disbursement percentages for the different years, all of which add up to 100%. In year 1 we would disburse...

Sorry bro but you'll have to elaborate on that a bit because I don't get it.

Thanks for the reply! Could you please point me in the right direction. How would I set the criterion for filtering which set of years I want? What usually happens is that the queries pick up values from three fields in a form to filter the results.

Hi I have a query to get 10 year values. Is it possible to run different queries based on when the sum of the values reaches 100. Is this possible? For example I can have 10 20 20 10 10 10 10 10 0 0 or 0 10 30 30 30 0 0 0 0 0 0 or any other number of combinations. In the first example, it...

lol... I thought the net connections here was bad. The speed is okay but there's just too much latency, that's actually why I use openDNS. Anyway, I'm totally lost regarding your advice. I started at it for 10 minutes but still couldn't understand, sorry. I've already got the calculations...

Hi GTH, The problem with treating it like an annuity is that the rate has to be fixed, the rate here is variable for every year. And I would rather have the calculated amount saved as I don't think it would make a difference in terms of data consistency. Is it possible to use a continuous form...

Hi everyone! I'm developing a financial projections system and 1 - I have a main form which has command buttons on it that open other forms, each of which have subforms. One form, Approvals, for instance, has 10 subforms in it. I use default value in the mainID (FK) field of each of the...

Thanks man, I've gotten rid of GeneralGrowth and added the fields to the GrowthVersion. Regarding portfoliomix and portfolio, I think I've already done that. One growth record has one portfolio with many portfoliomix records, hence the one to many relationship with portfoliomix. I think this is...

Apologies for the late response, I wasn't well. The growth in GeneralGrowth is the general growth rates for the ten years as a whole as they usually refer to projections by the year it was run, the growth and the version. So a projection could be for the year 2010, with a 15% growth rate and...

Actually I meant 600 fields in the form, not in the table. I've attached an image of the diagram so you get a better idea of my problem. And I just have an issue with the form design and being new to access doesn't help! What would be the best way of doing it? edit: In case you're wondering...

Thanks for the reply lagbolt! The project I am working on is a 10 year projections system. In the first module, 'Projected disbursements', we have different growth rates for 10 years, in each of those ten years we have 6 different finance types and in each of those finance types, we have 10...

Hi everyone Access newbie here. :-) I have a problem in which subforms don't commit records and values get copied to other subforms. I have one main form called Growth which is linked to a 'growth' table, in that form I have 6 subforms connected to a 'finance type' table, in each of those...