i have 4 fields. 1. Principle 2. IntRate 3. days 4. IntPerDay. I have to find interest per day and total interest
Me.IntPerDay.Value = Nz([Principle], 0) * Nz([IntRate], 0) / 36500 for per day interest
and
Me.Interest_Debit.Value = [Days] * [IntPerDay] for total interest
suppose i have principle amount 123.32 and interest rate 12.33 and day 5
then
i got
Interest per day = 0.0416 and
total interest = 0.2082
but i want
Interest per day = 0.04 and
total interest = 0.20
can it is possible.
Thank you in advance