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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
Click to expand...

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]
 
John Vinson said:
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]
Click to expand...

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
 
Back
Top