Hello is anyone can help me to create daily weekly and monthly loan schedule in ms access (1 Viewer)

Ganie

New member
Joined
Aug 25, 2015
Messages
27
Hello is anyone can help me to create daily weekly and monthly loan schedule in ms access.

im using excel sheet manually. is anyone can help to develop in ms access automatically.

Like
Daily payment schedule
Weekly Payment
Monthly Payment

Thank's. in advance.
 
Here is a recent thread that should help. You use the Pmt() function. It has several arguments. It is intended to work with the number of payments per year. I have never tried it with anything other than monthly = 12 or bi-weekly = 26 per year. Weekly would = 52, Daily makes no sense but it would b 365.

 
Here is a recent thread that should help. You use the Pmt() function. It has several arguments. It is intended to work with the number of payments per year. I have never tried it with anything other than monthly = 12 or bi-weekly = 26 per year. Weekly would = 52, Daily makes no sense but it would b 365.

Hello Thank you,

But how can i execute this in access newbie here.
my excel table is like this.
 
Hello Thank you,

But how can i execute this in access newbie here.
my excel table is like this.

Ongoing Balance35830Cash on Hand10
S#CustomerIDNameInvestorProgramCredit Amount+InterestDate StartDue DateMonthDurationPrincipalInterestSavingsWeekly PayStatus
180001Customer 1Investor 11 Week10604-Jul-2311-Jul-23Jul.231 Weeks1000601060Pending
280002Customer 2Investor 223 Weeks161004-Jul-2311-Jul-23Jul.23Week 1 (23 Weeks)43517491700Pending
380003Customer 3Investor 3Monthly55004-Jul-234-Aug-23Jul.231 Month50005005500Pending
480004Customer 4Investor 14 Weeks19604-Jul-2311-Jul-23Jul.23Week 1 (4 Weeks)375112487Pending
580005Customer 5Investor 210 Weeks112004-Jul-2311-Jul-23Jul.23Week 1 (10 Weeks)8003201120Pending
761011668867
 
PLease check my excel table maybe you can help me. or maybe someone is selling with the same. Thanks
 

Attachments

Last edited:
Here's a sample. I posted code and arnelgp put it into a database. One or both should help. It is called an amortization schedule.

 
Here's a sample. I posted code and arnelgp put it into a database. One or both should help. It is called an amortization schedule.


Hello,

I found this file with other thread but only limited up to 10 weeks (im getting this error)is anyone can help me to extend the weeks up to 24 weeks. Thank's in advance.


1689879058771.png
 

Attachments

I guess you are using arnelgp's solution. I pointed out this error to him in the original thread. He hasn't been around much lately.

Are you getting the error for all variables or just some? See if you can substitute the code I posted instead.
 

Users who are viewing this thread

Top Bottom