How can I interpolate missing data in a Table with a query.

[counter]

I want to interpolate missing data. I want to run a query so that it will
return all the real and interpolated values. My rable looks like this

Week Value
1 5
3 15
4 22
5 24

And As a result I want to get

Week Value
1 5
2 10
3 15
4 22
5 24

It can be a VB function or a query.

 

[John Vinson]

I want to interpolate missing data. I want to run a query so that it will
return all the real and interpolated values. My rable looks like this

Week Value
1 5
3 15
4 22
5 24

And As a result I want to get

Week Value
1 5
2 10
3 15
4 22
5 24

It can be a VB function or a query.

I'm confused. How is this interpolated value calculated? The average
of the values in week 1 and week 3? What would you want if you had

Week Value
1 5
6 6

What's the datatype of Value? Will it support fractions?


John W. Vinson[MVP]

 

[counter]

I'm confused. How is this interpolated value calculated? The average
of the values in week 1 and week 3? What would you want if you had

Week Value
1 5
6 6

What's the datatype of Value? Will it support fractions?


John W. Vinson[MVP]

Datatype is double and it supports fractions so in te example you gave the
result will be

1 5
2 5.2
3 5.4
4 5.6
5 5.8
6 6

Thank you

Kunter