var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Interest Rate
I am creating a budget database for personal use...I am trying to create a calculation that will calculate and add my interest automatically.
I am new to sql(about a week of reading] but I think it would look something like
select [interestrate], [interestrate] / 12 / [days of month] as periodic rate, [balance] * [periodicrate] as interest from budget;
My syntax is probably all messed up but I usually have to feel my way through sql, just wanted to show that I am not a total slacker.
How do I automatically put in the days of the month since the number of the days in the month are a part of the calc.
can I reference to a calculation (periodic rate) that I just made
I dont know if this is possible in sql ....just went that way because I know nothing about vb.
Last edited by slacker73; 10-26-03 at 16:24.
You could use the day function...
If you want the number of days in the current month:
day(dateadd("d",-1,Dateadd("m",1,cdate(format(date(),"yyyy/mm/dd") & "/" & "01")))))
I am sure you could use these same functions to make it smaller and easier to understand, but within 2 min...