Hi, Kent.
I have a serie of values like:
Month Value
1 100
2 200
3 300
4 400
5 500
6 600
7 700
If I would like to predict the value for month 12.
In Excel it's:
=PRECICT(predicted X;known y-values;known x-values) = 1200
How can I do the same in Access?
Access doesn't have the same built-in feature. However, Access is highly
customizable, so an Access developer can write custom VBA procedures to do
the task. In other words, you'll have to do the math.
Further, since what you've displayed is obviously calculated values, you
should be warned not to store those calculated values in a table, since they
can change. Store only the values needed to do the calculation, (i.e.,
SalesMonth and Rate). In addition, don't use Reserved words for
idenitifiers (names of tables, columns, queries, VBA procedures, variables,
et cetera), because it introduces bugs that are often hard to trace. Month
is a Reserved word.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs:
www.DataDevilDog.BlogSpot.com,
www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
