Auto add a new record on specified date.

[wesley.allen]

Hello All. Thank you for looking.

I am building a database to track rent payments for a building.
There
are about 10 businesses/tenants that pay monthly rent. All rent
payments are due on the first of the month for various amounts. I
have a main table "TenantsMain" that lists the detail for each
tenant. The first row is the primary key, which is "Company Name".
There is another table "TenantsRent" that lists the rent history for
each tenant, which has dates listing the various rents over time,
that
increase every few years. In the final table, "TenantsPayments", I
will track the payments as they are received. I would like to have a
query that will automatically run a few days prior to the first of
every month, which will add a new record to the "TenantsPayments"
table, adding a payment due date and the current rent due for each
tenant listed in my "TenantsMain" table. Is this possible?


I am not very good with code, so I usually use the wizards or design
view to build tables and queries. Any help you can provide would be
most appreciated,


Thanks.