Dim jb As new SQLJoinTableBuilder("查询表1","销售明细")
jb.C
'jb.AddTable("订单","产品ID","产品","产品ID")
jb.AddExp("店名","店名")
jb.AddExp("对账品名","对账品名")
jb.AddExp("对账品类","对账品类")
jb.AddExp("价格分析列","价格分析列")
jb.AddCols( "数量","标签价格")
jb.AddExp("金额", "[数量] * [标签价格]")
jb.Filter = "店名 = '" & e.Form.Controls("ComboBox1").value & "'"
jb.Filter = "对账品名 = '" & e.Form.Controls("ComboBox2").value & "'"
这两个什么关联
jb.Filter = "店名 = '" & e.Form.Controls("ComboBox1").value & "'"
jb.Filter = "对账品名 = '" & e.Form.Controls("ComboBox2").value & "'"
|