Add Sum Column to table

[robdunfey]

Hi,

I generate a table, the change the field types to number(Ihave done this bit). Then I want to add a column to the table that averages certain columns in the table. Is this possible? If so could anyone give me some example code/tips or pointers?

Any help much appreciated.

Rob

 

[mp9]

My gut-feel is that you shouldn't store derived values in the underlying table. Instead, just calculate your derived fields where they are needed, e.g. on a form or in a report.

http://www22.brinkster.com/accessory/

 

[LittleSmudge]

It's more than a 'gut feel' - its an absolute NO NO.

If data can be derived soley from other data in the record then it has no place being stored in the table in a field of its own.
Normalisation Rules
Data Integrity
etc.. ..

 

[sshah254]

Inspite of the above warnings, if you still want to do what you asked for, then use the

docmd.runsql "Alter Table TableName Add Column ColumnName Double;"
and
Docmd.Runsql "Update TableName Set ColumnName = ...;"

Sandip
shahs@Microdental.com