Input to Table

[Guest]

To keep it simple, I have a table and in it there are three number fields. I
need a fourth field that is the average of the three fields. I've made a
query that does just that. N4(N1+N2+N3)/3)

My question is how do I now get the results from the query (N4) to write to
the table so the information is all it the table? As the numbers change the
queries automatically averages the changes. Is there a way that the query
will keep the table up to date also?

 

[John Spencer]

Don't store the result. You can always calculate it when it is needed.

Storing it means if you ever update any one of the values, you have to be
sure that you do the calculation and store the new result. Calculating it
means the calculation is always correct.

You cannot do this by simply running a SELECT query.

 

[Guest]

Understand, make sense.

Thanks

Steve

Don't store the result. You can always calculate it when it is needed.

Storing it means if you ever update any one of the values, you have to be
sure that you do the calculation and store the new result. Calculating it
means the calculation is always correct.

You cannot do this by simply running a SELECT query.