Creating A Payment Database 1

[PU36]

I'm attempting to create a database that tracks payments based on monthly or weekly installments and could use some assistance. Example: If the student belongs to Room 5 their cost is $500 per month. The payment is due on the 4th, if they pay $275, the remainder amount is transferred forward and is due on the next due day of the 4th.

I believe I have create the table structure and relationship, but I can't figure out how to accept a partial payment and have the due date advanced to the next month.

Does anyone have any examples of this type of database?

Is this something that Access can do?

 

[TheAceMan1]

How are ya Magnum1976 . . .

Post the structure you have!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

Magnum1976 . . .

Since my prior post failed, what you need is a way to track [blue]running sum of payments[/blue] versus [blue]running sum of cost.[/blue] This is a direct parallel of a bank account comprising Debits & Credits.

I see two tables, one comprising the student info (main table) and one comprising the two running sums above (the many table). The difference of course, is the students balance!

[blue]Your Thoughts . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]