我表里有两条记录,只是这两条记录的金额是一样的,为什么统计的时候只作为一条记录来统计呢
Dim jb1 As New SQLJoinTableBuilder("查询表1","辅助总账")
jb1.AddTable("辅助总账","科目编码","科目档案","科目编号")
jb1.AddTable("辅助总账", "部门编码","责任中心档案","部门编号")
jb1.AddCols("科目编码","成本大类","公司","会计期间")
jb1.AddExp("金额","贷方金额")
jb1.Filter = "(科目编号 like '6001%' or 科目编号 like '6051%' or 科目编号 like '6301%') And (" & filter & ")"
Dim jb2 As New SQLJoinTableBuilder("查询表1","辅助总账")
jb2.AddTable("辅助总账","科目编码","科目档案","科目编号")
jb2.AddTable("辅助总账", "部门编码","责任中心档案","部门编号")
jb2.AddCols("科目编码","成本大类","公司","会计期间")
jb2.AddExp("金额","借方金额")
jb2.Filter = "科目编号 like '6601%' or 科目编号 like '6602%' or 科目编号 like '6603%') And (" & filter & ")"
jb1.Union(jb2) '组合jb2
jb1.Build()
如果只用jb2是没问题的,一组合就有问题