Regression Modeling in Query

[SKV]

I want to use regression analysis to estimate savings. I have 2 tbls, TblA and TblB
TblA - has ID, yr, mn, Svg for actual months (if proj started in Mar and today is May, it will have only March, April and May data ONLY)
TblB - has ID, yr, mn, Pvol for 12 months

I want to correlate Actual svgs with the Pvol and then project savings based on the Pvol for that month (ie for June to Dec)

Every month my Actual will increase by 1 and no for months to be forecasted will be decrease by 1.

How can I make this fully automated?

Thx
SKV

 

[jackd]

I want to use regression analysis to estimate savings. I have 2 tbls, TblA and TblB
TblA - has ID, yr, mn, Svg for actual months (if proj started in Mar and today is May, it will have only March, April and May data ONLY)
TblB - has ID, yr, mn, Pvol for 12 months

I want to correlate Actual svgs with the Pvol and then project savings based on the Pvol for that month (ie for June to Dec)

Every month my Actual will increase by 1 and no for months to be forecasted will be decrease by 1.

How can I make this fully automated?

Thx
SKV

Can you show us a little of the "arithmetic" involved? You can autoamte the recalculation based on Date and existing stored values, but we need to know a little more about the calculations involved.