Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
Dim b As New SQLGroupTableBuilder("统计表1","订单")
b.Filter = "[产品] = 'PD01'"
b.Groups.AddDef("产品") '根据产品分组
b.Totals.AddDef("数量") '对数量进行统计
b.Build '生成统计表
Maintable = Tables("统计表1") '打开生成的统计表
b.Filter = "[产品] = 'PD01'" 产品名称来自组合框 ComboBox1 这个表达式如何写呢?
b.Filter = "[产品] = '" & e.Form.Controls("ComboBox1").Value & "'"
建议看看:
http://help.foxtable.com/topics/1284.htm