sql="Select tpmbom1.id,tpmbom1.件号,tpmbom1.品牌,tpmbom1.类别,tpmbom1.等级,tpmbom1.库位,tpmbom1.位置,tpmbom1.最低库存,tpmbom1.最高库存,sum(tpminout1.入库数量-tpminout1.出库数量) as 库存数量,sum(tpminout1.入库数量)-sum(tpminout1.出库数量)-(tpmbom1.最低库存) as 最低库存差,sum(tpminout1.出库数量)-sum(tpminout1.入库数量)+(tpmbom1.最高库存) as 最高库存差 from tpmbom1 join tpminout1 on tpmbom1.件号 = tpminout1.件号 where 日期 between '"&dtpr1&"' and '"&dtpr2&"' and tpmbom1.件号 like Quotedstr(%'"&kit&"'%) or tpmbom1.品牌 like Quotedstr(%'"&kit&"'%) group by tpmbom1.件号,tpmbom1.品牌,tpmbom1.类别,tpmbom1.等级,tpmbom1.库位,tpmbom1.位置,tpmbom1.最低库存,tpmbom1.最高库存,tpmbom1.id order by 最低库存差 asc"
----------------------------------------------
-