I have one table that has a balance in it. I have a second table that has the interest amount and date interest is effective. I need a way to calculate today's balance.
Let's say Balance1 is $100.00 as of 12/31/2007. For the period 12/31/2007 - 12/31/2008 interest was 5%. For period 01/01/2009 - Current interest is 7.25%. How would I calculate that? I don't necessarily need to do this in a query. I could do this in VB if that is easier.
I am at a total loss on this one. Any and all help will be much appreciated!