Ajax,
You’re solution isn’t truly recursive. Take a look at the column bga in your solution. You add .2982 to bga every time (.2982+.2982 = .5964, .5964+.2982 = .8946, 1.1928+.2982 = 1.491) – that’s linear and not exponential like this formula needs to be. I don’t need recursion to do that.
Next, look at my table which I produced via VBA in this thread (not SQL like what you did). Notice that my bga column is slightly different than yours – it’s because it uses recursion bga(n-1)+bmg, i.e; .2982+.3003= .5985 .5985+.3024=.9010, .9010+.3046=1.2056. Although this difference may seem small for the sample size I provided, the difference gets very large over the course of several weeks. Also, correct me if I’m wrong, but I didn’t think Access had SQL recursive support like other platforms such as mySQL and Oracle. That’s why I wrote this using VBA and made it a separate post.
Also, my function already calculates the recursive values I need for all columns (that's not what this post is about). I just need some help posting it to the query - currently, I'm using a scripting.dictionary method and am just looking for help in translating that to a dynamic multi-dimensional array (arr() as double) which I think needs to take place. I also tried to be as detailed as I could in the demo file I attached to hopefully save time.