Wednesday 15 June 2011

sql - Calculating the average of 2 columns and writing the result in an existing column -


I have an access database in which I have 2 column values.

In this one, I have a third column in the same table, I would like to keep an average of these two columns

Demping

What is the best way for me to do this?

I need to save the average in "reDidiming" because I need that report later

It is not best to calculate and store the average unless you have a specific reason to do so. The proper form of contact with this is a query where you can calculate the average 

  MyTableName  as SELECT GemetenDe1, GemetenDe2, (GemetDe1 + GemetenDe2) / 2 / Pre GementenDeAvg>
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)