Hi,
I am working on a Database to get rid off a nightmare Excel Spreadsheet for tracking rentals for a homeless program I work for. I am trying to work out how to get an accurate rent calculation that needs to keep track of rent to date changed, payments etc. It will often need to factor in pro rated rents.
EG Rent table shows Date the rent Started lets say 8/23/12 with a rent amount of $650 a month, the calculation for rent would be something like this:
August $650/31(days)*(8/23/12 to 8/31/12 = 8 days) = $167.74
September $650 - total Rent to Date is $ 817.74
October $650 - total Rent due is $1467.74 Etc
I would like to see this result in a field that is shows totals for clients like such:
Client Jane Doe
Rent Start Date End Date Rent to Date
650 8/23/12 1/2/12 1511.07
550 11/2/12 128.33 (this is until today's date)
I hope that makes sense... more so I hope someone is inspired enough to tackle this issue and get me to the result I need.