Need some direction

[sandylt]

I am trying to track payments due. I have each account set up with a due date. If they are current i have no problem My problem results when an account is past due. What I would like to do is create a table that shows each month, year, quarter, etc. period that is due and then past due starting with the last date they are due on. Example: The account was last paid for May. So they are Due on 6/01/2004 on a monthly payment. The first line in the table would show 06/01/2004 $50.00. I would like to have the form create a row for each month in between the due date until now. THen the month currently due.
past 06/01/2004 $50.00
past 07/01/2004 $50.00
past 08/01/2004 $50.00
Current Due 09/01/2004 $50.00
Total $200.00

Then clear it out and start over when the balance is paid.
Any ideas???

 

[Pat Hartman]

I would create a monthly "invoicing" query. The query would append a record for all active accounts for the billing month. Then your Invoicing query would select all unpaid invoice items. Once you are caught up, there would be no need to generate extra records. Each month when you run invoicing, a new record would be generated for everyone whether they were current or not as long as they are active.