Lending Sample System
Good Day everyone..
i badly need help... i started this simple thesis of mine last 2 months ago. and i wasn't nearer to completion. this will be submitted next week..
please do help me sir's,,
this is a MS Access..
my question is i cannot save the AGE to the Table which is derived from Current Date - Birthday = AGE., calculation already appeared in my text box. but the problem is when i saved it.. AGE in the TABLE is empty..
2ndly
how can i link the two tables to appear in one form?
i have Payment (Table) and PaymentDetails (table)
in payment table is composed of
CustID
LoanID
PaymentID
Balance
and for the PaymentDetails is
PaymentID
PaymentDetailsID
Date Paid
Amount
Current Balance
in my Payment Form i put a List Box to show how much is the remaining balance.. and show the loan date until matured date divided the Loan Amount to 30 days from the loan date until matured date..
and of course to show the history of each payment..
please do help me guyz..
if only i can attach my program..
|