主题：统计表的时段筛选

bd2.Filter="dDate>#" & new Date(2015, 1, 1) & "#"

 那就说明没有符合条件的数据，请好好看看你的 dDate列

 看7楼，如果有数据，试试用SQLGroupTableBuilder

 

http://www.foxtable.com/help/topics/1626.htm

 

 Dim b As New SQLGroupTableBuilder("统计表1","P_OutList")
b.Filter="dDate > '" & new Date(2015, 1, 1) & "'"
b.Groups.AddDef("cPCode","产品编号")
b.Totals.AddDef("nOAmount","销售数量")
b.Build
MainTable = Tables("统计表1")

 写错了，不可能不行。不行就请上传例子说明

 

bd2.Filter = "[dDate] > #" & Tables("采购统计日期").current("起始日期") & "#" 

 

 或者

 

bd2.Filter = "[dDate] > '" & Tables("采购统计日期").current("起始日期") & "'" 

改成这样看卡

 

[dDate] > '2015-01-01'

 

或者

 

[dDate] > #2015/01/01#

 

不行，就做个例子上来

无语

 

Dim bd2 As New GroupTableBuilder("统计表2",DataTables("订单"))
Dim dt2 As fxDataSource
bd2.FromServer = True
bd2.Filter = "[日期] > #2000-01-01# "
 'bd2.Filter = "[产品ID] = 'P05'"    
bd2.Groups.AddDef("产品ID")  '根据型号分组
bd2.Totals.AddDef("数量") '对数量进行统计
dt2 = bd2.BuildDataSource()
dt2.Show("统计表2") '显示统计结果

 代码没有问题

Dim bd1 As New GroupTableBuilder("统计表2", DataTables("P_OutList"))
Dim dt1 As fxDataSource
bd1.FromServer = True
bd1.Groups.AddDef("cPCode")
bd1.Totals.AddDef("nOAmount")
bd1.Filter = "[dDate] > '2013-03-01'"

dt1 = bd1.BuildDataSource()
dt1.Show("统计表2") '显示统计结果

 看楼上，看10楼啊