My statement is
The module is to gain the last paid and the next to be paid dates from a list of transactions for a payment schedule
The first one above is finding the duedate of the last paid or submitted payment
The second above is finding the next duedate that is Not Paid
Any help from a fresh view would be really appreciated
Code:
Me.LastPaymentDateFld = DMax("DueDate", "DdSchedDDTrans", "DdSchedId = " & Me.DdSchedIdFld) & " AND ([TransCode] = 13 " & " Or [TransCode]=50 " & " Or [TransCode] = 20) " & " AND ([Status] = 'Paid' OR [Status] = 'Submitted')),0)
Me.NextPaymentDateFld = DMin("DueDate", "DdSchedDDTrans", "DdSchedId = " & Me.DdSchedIdFld) & " AND ([TransCode] = 13 & [Status] = 'Not Paid')),0)"
The module is to gain the last paid and the next to be paid dates from a list of transactions for a payment schedule
The first one above is finding the duedate of the last paid or submitted payment
The second above is finding the next duedate that is Not Paid
Any help from a fresh view would be really appreciated