UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Loan Payments, Any Version    
 
   
iranbir
post Feb 16 2018, 11:56 AM
Post#1



Posts: 2
Joined: 21-January 16



Hi,

my query is bit similar to this previous discussion.

where we have 2 tables in which amount of advance is store tbl_Drawdown (with DDNO as PK) and other tbl_BankPayout (with DDNO as FK). I am trying to calculate interest on the basis of days advance is used and balance available the advance is settled.

I have tried few options but couldn't of much success, Sample Data is attached.

kindly assist and guide in accomplishing the task.

Thanks
Attached File(s)
Attached File  Sample.zip ( 761.18K )Number of downloads: 22
 
Go to the top of the page
 
zaxbat
post Mar 3 2018, 06:44 AM
Post#2



Posts: 1,184
Joined: 26-January 06
From: .....the wiregrass (either you know or you don't)


You need to define a trigger for the interest calculation. It could be done automatically at program start up and calculate all records. It could be done automatically on a single record when the needed data is all input. It could be done manually on a single record (or even for all records) when a button is clicked. You need to make this decision.

You need to provide the formula to calculate the interest.

If you provide these things I can help.

--------------------
Kindest regards, and Cheers!
ZAX

A picture is worth a thousand words and a zipped DB is worth a thousand pictures.
Oh, and....please don't disappear into the Twilight Zone.... Holler back with your results!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 04:03 AM