Bi-weekly due dates for loan repayments

[jlayaoen]

Hi. Currently doing a program to calculate the loan repayments with due date, principal, interest and fortnight amortization. May I ask how do I calculate the repayment type to bi-weekly or fortnightly and populate the schedule of due dates bi-weekly automatically from the start date of payment. I only know for the weekly calculation i.e. DueDate = DateAdd("ww", intNumber, Me!Date)

Thank you so much in advance.

 

[isladogs]

You can use

?DueDate=DateAdd("d",14,Me.Date)

Note that you shouldn't use Date as a field name as it is a reserved word in Access

 

[arnelgp]

also
intNumber = 2
DueDate=Me!Date
DueDate = DateAdd("ww", intNumber, DueDate)

 

[jlayaoen]

also
intNumber = 2
DueDate=Me!Date
DueDate = DateAdd("ww", intNumber, DueDate)

Hi Sir ArnelGP.

Thank you for your reply. I tried your suggestion and it was okay on the first due date but the succeeding due dates were only 1 week apart or weekly. If I may attached here my form for your reference please. Note that the first due date should be the same as the starting date of payment. I also wanted to add a combo box to select the frequency of repayments and calculate the same. Appreciate your help.

 

[Gasman]

A computer only ever does what you tell it to
This is what you have

    intNumber = 0
    DueDate = Me!Date
 
    Do While intNumber <> Me.Term
    
        'dbs.Execute "INSERT INTO [Application Form Details] ( AppID, Number, Interest, Total ) VALUES (" & Me.AppID & ", " & intNumber & ", '" & curInterest & "', '" & curTotal & "');"
        With rst
            .AddNew
            !AppID = Me!AppID
            !Number = intNumber
            !DueDate = DateAdd("ww", intNumber, DueDate)
            !Interest = curInterest
            !Total = curTotal
            .Update
        End With
        
        intNumber = intNumber + 1
    Loop
    Me.Refresh
End Sub

Nowhere in that code do you attempt to calculate what intNumber is meant to be?, you just increment it by 1, which is weekly?

 

[arnelgp]

see the changes in the code and in table Frequency.

 

[jlayaoen]

see the changes in the code and in table Frequency.

Hi Sir Arnelgp.

Thank you very much. You've done exactly what I need. Appreciate it Sir.