"Tom van Stiphout" wrote

That depends. I look at this as a Math

problem, with some X,Y values, and

some additional X-values where we want

to know the Y-value. Typically you'd want

to do some sort of interpolation. Perhaps

straight lines between the known points

(linear interpolation), perhaps a smooth

line (e.g. a cubic spline).

But, without more information on what kind of data it is and/or how it is

derived, we couldn't suggest what method would be appropriate. I remember

taking a numerical analysis class in which, to point out the fallacy of

assuming the missing values could be calculated with whatever method we were

learning, the teacher gave a similar list with some missing values. It

turned out that no one's suggested method would work... it was a list of

room numbers in the building and the number of chairs/seats in the room.

And, as the missing numbers were associated with things like broom closets,

other janitorial rooms, and storage rooms (which contained neither seats nor

chairs) and one storage room that was stacked, jammed-full, floor to ceiling

with extra folding chairs (which contained all the extra chairs for the

entire building)... there was no "method" that could be used to _calculate_

them.

If the ghanley's teacher gave this as an assignment, ghanley had best go ask

for more information. If it is some real-world situation, then ghanley

should carefully consider if it is a problem that lends itself to a

calculated solution.

Larry Linson

Microsoft Access MVP