Search results

arnelgp You did it again. God bless you and thanks again.

Hi June7, Thanks for the advise. However i get the following error msg "syntax error in join operation" Attached is the sample DB. Kindly assist rectify this.

Please find attached zip file with sample DB.

Hi arnelgp Please find attached the sample DB. Thanks.

That is true. Can you kindly help?

I forgot to attach the file. Please find attached.

Hi arnelgp The amortization script worked like a charm. Thanks again. I just have another kind request regarding, creating a calculated field (named "Total_Payment" - highlighted yellow in the attached excel sheet) in 1 table called "Loan_Schedules" that sums values from another table called...

Hi All, I need some help from the experts. I need to create a calculated field (named "Total_Payment" - highlighted yellow in the attached excel sheet) in 1 table called "Loan_Schedules" that sums values from another table called "Payments" based on 2 criteria (the Loan_ID and Schedule_ID) and...

Will do and give you feedback once done. Thanks again arnelgp.

arnelgp You are a true GENIUS (all caps) thank you very very much.

Thank you all for your comments. Don't pay to much attention to the repayment columns i.e. columns I to O. I am building a loan origination database in access. And all that is left is to create a loan schedule in access. However, I can create it in Excel easily, but replicating the same in...

Hi all, I am new to the forum and using ms access. I would really like some help creating the attached excel loan schedule in access. The fields shaded yellow would be populated using a form and those shaded green would be calculated in the db. Please kindly assist with the request :banghead: