以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 怎么统计各人总的工作量 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=138506) |
||||
-- 作者:xblxbl -- 发布时间:2019/8/2 11:03:00 -- 怎么统计各人总的工作量 请教,怎么按人员统计出各人总的工作量。
|
||||
-- 作者:有点蓝 -- 发布时间:2019/8/2 11:49:00 -- 参考:http://www.foxtable.com/webhelp/topics/1454.htm 结合下面用法: Dim us As String = "甲" Dim str() As String = {"一","二","三","四"} Dim sum As Integer = 0 For Each s As String In str sum += DataTables("表A").Compute("sum(工序" & s & "_价值工作量)","工序" & s & "_作业人员=\'" & u & "\'") Next msgbox(sum) |