sql1 = "Select 商品代码,商品名称,sum(入库数量) as 入数汇总,sum(入库金额) as 入金汇总 from ruku where 入库日期 <= #" 2012/7/18 "# group by 商品代码,商品名称"
我要想改成是2012/7/01到2012/7/18中间的数量怎么写啊,
谢谢你的提示,sql1 = "Select 商品代码,商品名称,sum(入库数量) as 入数汇总,sum(入库金额) as 入金汇总 from ruku where 入库日期 between #2012-7-1# AND #" & 进销存查询窗口.截止日期.Text & "# group by 商品代码,商品名称"