Generate payment Calender

[Buzzybee]

Hi,



New here. I use Access 2013. Is there an easy way to do the following:

I have a contract that starts on eg 01/07/2015. Tenant has to pay 100€ each month. Is there a way to create a query/table/... where access automaticaly makes a duedate?

EG:

Joe needs to pay me 100€ each month, starting 01/01/2015 until 31/12/2018.

This means:

01/01/2015 - due 100€ from Joe
01/02/2015 - due 100€ from Joe
...
01/12/2018 - due 100€ from Joe

Where I can mark items paid

[ranman256]

At the 1st of each month , I run 'processing'. This query appends a 'rent' due to each persons acct (tClientRent)
It is charged, then when a person pays the fields
tClientRent.AmtPd = 100
tClientRent.DatePd = 1/1/18

Another query runs, update query, that checks the Clients 'escrow' (paid future rent) and pays off the current rent, then reduces escrow.
After 3rd day of the month, a select query give me the list of unpaid renters.