Keeping a balance

[dsomers]

Hello all! On my real estate management software I have a couple of quirks that I've come across that I need implemented within my query.

To begin with, I have fields: Balance, Prev. Balance, Late Fee, Monthly Rent, Rent Paid, Date Rent Paid. Here's what I want to do:

1. Set balance to 0 at the end of each month and if there is an outstanding balance, have that added to Prev. Balance. This must be automated. Not sure how to do this in a query, in something like C++ or something it would be PrevBalance = PrevBalance + Balance.

2. I need to be able to click a button on a form and add the late fee to all tenants with an outstanding balance for the month. That is if they haven't paid by the fifth, I want to add 5% of their Monthly Rent to the Balance.

3. Must have Rent Paid and Date Rent Paid cleared at the beginning of each month. This must be automated.

I'm not sure how easy or hard this is. But if anyone can guide me, I'd be really grateful!

Thanks!
David Somers

 

[Rich]

Since you've already had some help, I find it extraordinary that you ignore your previous posts and simply post the same questions again. If you don't understand the response or want further help then return to the original post and say so