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    
post Feb 16 2018, 11:56 AM

Posts: 2
Joined: 21-January 16


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.

Attached File(s)
Attached File  Sample.zip ( 761.18K )Number of downloads: 19
Go to the top of the page
post Mar 3 2018, 06:44 AM

Posts: 934
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!

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    21st June 2018 - 02:43 PM