主题：统计的合计值怎么写入另外一个表

 参考

http://www.foxtable.com/help/topics/2720.htm

Datacolchanged事件代码

If e.DataCol.Name = "保洁员" Then
    Dim cns() As String = {"一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"}
    If e.NewValue = Nothing Then
        For Each cn As String In cns
            e.DataRow(cn) = Nothing
        Next
    Else
        Dim filter As String = "(保洁员 = '"  & e.DataRow("保洁员") & "' or 保洁员 like '%," & e.DataRow("保洁员") & "' or 保洁员 like '%," & e.DataRow("保洁员") & ",%' or 保洁员 like '" & e.DataRow("保洁员") & ",%')"
        For i As Integer = 0 To cns.Length - 1
            Dim d As Date = new Date(Date.Today.Year, i+1, 1)
            e.DataRow(cns(i)) = DataTables("派工表").compute("sum(人均价)", filter & " and 日期 >= #" & d & "# and 日期 < #" & d.AddMonths(1) & "#")
        Next
    End If
End If

1、拷贝代码进去；

2、输入保洁员的名字，或者重置列保洁员列。

1、你在maintablechanged加入重置列的代码即可

http://www.foxtable.com/help/topics/1587.htm

2、或者你删除重新填入保洁员的名字，也会重新计算的。