Hi Everyone,
Let me just begin by saying I am a complete idiot when it comes to Access. The first time I used it was about 4 weeks ago and I've been self teaching myself the software (with little success) for that time. I've built a relatively nice (simple)...(Very simple)... database which does most of what i require but I did not use any coding nor have any knowledge of coding so if you know the answer to my question and it requires coding please can you explain it to me as you would a child. Novice doesn't begin to explain my level here.
Anyway onto the issue. As it stands I have a query that includes several columns, one of those columns shows returns on investment as a percentage. I need to figure out the annualised returns on investment using the following excel formula
{=PRODUCT(1+B1:B24)-1^(12/24)-1}
This formula gathers the percentages for the last two years then provides an annualised amount.
I'm just wondering whether this is possible to apply to the query so that when I open the query it can provide me with the 2 year annualised statistics.
If I've done a poor job of explaining my issue my apologies because I really don't know how to describe my problem and I'm fairly sure I solution doesn't exist but if anyone has any idea they would be greatly appreciated.
Many thanks.