Hi,
I currently have data in two tables. In one table is the master record for a loan. It has fields like name, id, loan id, loan date, and amount.
The other table has details on the amounts given out to the person. since the start of the loan. A loan period is 10 years. I wanted to create a table (or query) that puts the amounts in monthly "buckets" from the loan start date so I can trace the disbursements. I want to do this in a table or query so I can run some other calculations. Like possibly grouping the monthly periods into annual periods.
I am also not sure what is the first date of the first loan in the data so how would the table / query be flexible if I say need to start in 1984 but go through 2004 or later?
Thanks,
Jeff
I currently have data in two tables. In one table is the master record for a loan. It has fields like name, id, loan id, loan date, and amount.
The other table has details on the amounts given out to the person. since the start of the loan. A loan period is 10 years. I wanted to create a table (or query) that puts the amounts in monthly "buckets" from the loan start date so I can trace the disbursements. I want to do this in a table or query so I can run some other calculations. Like possibly grouping the monthly periods into annual periods.
I am also not sure what is the first date of the first loan in the data so how would the table / query be flexible if I say need to start in 1984 but go through 2004 or later?
Thanks,
Jeff