I'm very new to Access and I've hit a wall. I'm developing a database in order to track rental property payments. My problem is that some rents are due weekly, some are due monthly. And the date that they fall due is based on when the move in date was.
I have no problem adding payments however I want to create a query (I think I want a query) that produces all the dates when each tenants rents are due.
EXAMPLE: If a tenant moves into a weekly unit today. Seven days from now the database automatically creates a new record in a table showing the TenantName, RentDueAmt, RentDueDate.
I’ve been able to create a new field (column) that calculates the next payment due date. However this is not what I need. I need all the payment due dates from move in till today.
Can this be done? How can I do this??
Thanks for the help.

The rent due should be calculated on a rolling basis dependant on the frequency and from the start of tenancy. You shouldn't store the date due it's a calculated field.

I could do that but...when a tenant misses or makes a partial payment I need to be able to generate a Report, Document, Table or something that details the rents due and payments received for a given time period. If I don't log the rent due dates how can I determine what the tenants owes in a format the tenant can also understand?

In simplified terms
RentDue:Int(DateDiff("w",[StartOfTenancy],Date()))*[Rent] will give you the rent due to date, deduct the sum paid and you have the balance.
Storing the due dates is a waste of space in a database, you should only store the weekly rent reqd. the dates paid, the amounts paid, plus any other relevant fields start and end of contract etc.
If you want to produce a detailed statement comparing dates due against dates paid then use a function to produce the dates due and delete them when the statement is printed.

Thanks Rich. I'll try to tackle it from that angle. Your help is greatly appricated