In MS Access 2010, I am working on Time table for Payment Frequencey.
I need to show Start Date , End Date for payment Frequency.
I assume that I will need some preset Time Schedul populated table.
User will be prompted to enter :
Number of Years =
Payment Frequency =
I can calculate total Number of Payments: e.g Number of Years 30; Payment frequency = Monthly so total Number of Payments = 360.
however I need to connect dates with those payments relating to start Date.
Start Date= Sep/01/2014
Number of Years = 20
Payment Frequency = Bi-weekly
I need something like :
Number of Payments Start Date End Date
1 09/01/2014 09/14/2014
2 09/15/2014 09/28/2014
To the end of schedule
Payment Frequency which could be:
1. Monthly (12 payments/year)
2. Semi-Monthly (24 payments/year)
3. Bi-weekly (26 payments/year)
4. Weekly (52 payments/year)
5. “Accelerated” bi-weekly (26 payments/year)
6. “Accelerated” weekly (52 payments/year).
Number 5 and 6 are the same relating date range as 3 and 4 just amount will be calculated on dif. way
What do I need to get this Payment Frequency Date schedule table?