提示错误：从字符串“[日期] >= #1/1/2011# And [日期] <= #”到类型“Long”的转换无效。麻烦老师指导下，谢谢
Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox2")
Dim g As New CrossTableBuilder("统计表1", DataTables("明细"), "[日期] >= #1/1/" & e.sender.value & "# And [日期] <= #12/31/" & e.sender.value & "#" And "类别 = '" & cmb.value & "'")
g.VGroups.AddDef("日期",DateGroupEnum.Year,"{0}年")
g.VGroups.AddDef("日期","{0}月")
g.VGroups.AddDef("部门")
g.VGroups.AddDef("类别")
g.Totals.AddDef("总价", "总价")
g.Totals.AddDef("数量")
g.Filter = "[日期] >= #1/1/" & e.sender.value & "# And [日期] <= #12/31/" & e.sender.value & "#" And "类别 = '" & cmb.value & "'"
g.Build()
e.form.controls("table1").Table.datasource = g.builddatasource()'窗口表数据等于该创建表
加好友 
发短信
Post By：2020/11/15 10:46:00 [显示全部帖子]
