Access Access - Automatically Show Payment Dates for loan

F

Fisherd

Joined
Mar 9, 2012
Messages
2
Reaction score
0
HELP! :cry:
Not very good with code or access lingo
This is what I currently have:
Loan info: Fields - Loan Amount
Date of Loan
Fee Amount
# of months
I need to amortize and have access calculate the monthly dates based on the date of the loan.
I have =DateAdd("m",1,[dateofloan]) that does give me the next months date, but I need to have all the dates automatically fill in based on the # of months
It sounds simple but I can't get more than 1 record to autofill in the report.
I think a macro might also work, but not sure of the code

Can anyone provide step by step?
 
i m working on a project where i have created a form for vendor payment. here we hire goods from vendor for particular task. so i just want to make auto-fill box. as i will enter task id, all the element which are used in the task must be automatically filled in the form of subform. and then we will make the total payment of complete element.


pls help, i would appreciate your feedback and support in this regard.


 
Back
Top