How can i create the Simple Interest with database

Question

How can i create the Simple Interest with each record of table?

when the month is change than the Interest is also update in the table on form_load() or any event....

I just want two thing...the SI for each record of table and also update when month is change

please see : https://goo.gl/n8ysBT

Amit Singh · Answer

Hey Amit Check this link 1.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=158736

amit varma · Answer

Hii Amit Singh thanks for posting.. can you please create the procedure for this table? please download table script : https://www.dropbox.com/s/uuulbg88q7401js/SQLQuery1.sql?dl=0