求救

Question

怎样在Access表中在最后一个字段中求出前几个字段的和？

Answer 1

adoquery1添加计算字段HeJi
再在adoquery1的onCalcFields事件里
写
adoquery1.FieldByName('HeJi').asFloat :=adoquery1.FieldByName('1').asFloat+
                                        adoquery1.FieldByName('2').asFloat+
                                        adoquery1.FieldByName('3').asFloat+   
                                             .
                                             .
                                             .

Answer 2

update yourtable set lastfield = field1+field2+.....