var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with query
I have a table containing the following fields:
[Rate1], [Years1], [Rate2], [Years2], [Rate3], [Years3]
where the tables starting with "Rate" contain interest rates applicable for a # of years as found in the corresponding "Years" field.
Take the following record, for example:
5%, 2, 6%, 3, 5.5%, 1
I need a query that will produce the following as output:
5%, 5%, 6%, 6%, 6%, 5.5%
This is just an 6 year example... In reality, I am dealing with 100 years.
I'm with poliarci on this one. If you're performing any calculations with rate and year you're surely not going to produce a % as the answer?