Creating a Payment Schedule Table
Posted on 2014-02-12
I would like to be able to create a table of scheduled payments based off data in another table. The fields I would have available would be: Payment Start Date, # of Months, and Payment Amount. So for example, if I had the following:
StartDate # of Months Amount
03/01/14 36 $250.00
I would want to create table that returns 36 rows with the start date being incremented for each month. I was thinking the ROW over command would work to increment the start date, but I'm not sure how to create the number of rows off the value of the field # of Months.