-- [求助]交叉统计
下列代码报错,请指点!
Dim b As New SQLCrossTableBuilder("统计表1","报名缴费")
b.Caption="表三"
b.C
b.HGroups.Adddef("所报学科")
b.HGroups.Adddef("任课教师编号")
b.VGroups.AddExp("年", "Year(缴费日期)")
b.Totals.Adddef("缴费编号",AggregateEnum.count,"人次")
b.Totals.AddExp("奖金","人次 * 3" ) \'每人次3元
b.Filter="任课教师编号=\'yfsh0435\'"
b.Build
MainTable = Tables("统计表1")
[此贴子已经被作者于2022/2/24 16:11:18编辑过]