初始数的科目汇总 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

msgbox(DataTables("初始数据_Table2").Compute("Sum(初始余额)","[科目代码] <> '负债总计' and len(科目代码) = 4"))

msgbox(DataTables("初始数据_Table3").Compute("Sum(初始余额)","[科目代码] <> '所有者权益总计' and len(科目代码) = 4"))

msgbox(.Compute("Sum(初始余额)","[科目代码] not in ('损益总计','负债和所有者权益(或股东权益)总计') and len(科目代码) = 4"))

rt5("初始余额") = DataTables("初始数据_Table2").Compute("Sum(初始余额)","[科目代码] <> '负债总计' and len(科目代码) = 4") + DataTables("初始数据_Table3").Compute("Sum(初始余额)","[科目代码] <> '所有者权益总计' and len(科目代码) = 4") + .Compute("Sum(初始余额)","[科目代码] not in ('损益总计','负债和所有者权益(或股东权益)总计') and len(科目代码) = 4")

msgbox(rt5("初始余额"))

主题：初始数的科目汇总