以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 流水账 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=120436) |
-- 作者:dansh -- 发布时间:2018/6/15 13:57:00 -- 流水账 我想把输入的表格内容,输出内容变为日期流水账,把下面代码复制到命令窗口,显示错误代码Select Case e.DataCol.Name,请问该怎么办? Select Case e.DataCol.Name Case "收入","支出" For Each dr As DataRow In e.DataTable.Select("[_SortKey] >= " & e.DataRow("_SortKey")) Dim Val1 As Double = e.DataTable.Compute("Sum(收入)","[_SortKey] <= " & dr("_SortKey")) Dim Val2 As Double = e.DataTable.Compute("Sum(支出)","[_SortKey] <= " & dr("_SortKey")) dr("余额") = Val1 - Val2 Next End Select
|
-- 作者:有点甜 -- 发布时间:2018/6/15 14:23:00 -- 参考这里
http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=96147&authorid=0&page=0&star=1
|