我想通过选择年度和月份,实现指定月份的统计,下面的代码运行后报错,请问哪里需要修改?请指教,谢谢!Dim ndxz As WinForm.ComboBox = e.Form.Controls("年度选择")
Dim yfxz As WinForm.ComboBox = e.Form.Controls("月份选择")
Dim g As New GroupTableBuilder("统计表1", DataTables("派工单明细表"))
Dim dt As fxDataSource
g.Groups.AddDef("派工日期", DateGroupEnum.Year, "年")
g.Groups.AddDef("村民组")
g.Groups.AddDef("户主姓名")
g.Totals.AddDef("工时")
g.Totals.AddDef("工价")
g.VerticalTotal = True
g.Decimals = 2
g.Filter = "[派工日期] >= #" & yfxz.value & "/1/" & ndxz.value & "# And [派工日期] <= #" & yfxz.value & "/31/" & ndxz.value & "#"
g.Build()
dt = g.BuildDataSource()
Tables("公用工查询_Table1").DataSource = dt