select case e.datacol.name case "第一列","第二列","第三列" e.datarow("第四列") = e.datarow("第一列")+ e.datarow("第二列") +e.datarow("第三列") Case "第四列" e.datarow("第八列") = e.datarow("第四列") *2 Case "第六列","第七列" e.datarow("第五列") = e.datarow("第六列")+e.datarow("第七列") Case "第五列","第八列" e.datarow("第九列") = e.datarow("第五列")+e.datarow("第八列") Case "第六列","第九列" e.datarow("第十列") = e.datarow("第六列")+e.datarow("第九列") end select