I am designing a Housing Database to track rent payments for Non-For-
Profit organization and they calculate/figure the tenant/client's Rent
payment based on how many room mates. No Problem, Rent is set at apt
#1 for $750/month, 3 people share the apt so $750/3 yields $250 for
client #1, $250 for client #2, and $250 for client #3. Here is the
problem. They do not calculate rent based on equal payments for all
shared clients in one apartment, however they calculate based on how
much income each client gets from the State to find the weighted
percentage to contribute to the Total rent. Client making less money
should not be subject to same payments as client receiving more state
aid. (See example below)
Client #1 pulls $10,000 annually, so $10,000/(10,000+12,000+15,000) =>
27%
Client #2 pulls $12,000 annually, so $12,000 / (10000+12000+15000) =>
32%
Client #3 pulls $15,000 annually, so $15,000 / (10000+12000+15000) =>
41%
Taking the percentages from above I need to re-step thru the detail
section and calculate the rent ****tions for each client:
Client #1 .27 * $750 => $202.50
Client #2 .32 * $750 => $240.00
Client #3 .41 * $750 => $307.50
SO my issue with access is that I can setup a footer Group right below
the detail section and calculate this information with no problem.
wrong. The issue is to sum the annual figure in the group section,
but how do I step back and get the individual 10000, 12000, 15000
numbers...
I believe I have reached an issue that Access can not resolve...
Any recommendation in how to get the Rent ****tions for each Client in
a re****t would be greatly appreciated.
This database is completely done and just need to fix this issue.
thanks, Jeff Harris (harris@[EMAIL PROTECTED]
)
|
