本帖最后由 车仁静 于 2013-11-19 13:14 编辑
- SELECT 机型,SUM(上月结存) AS 上月结存 ,SUM(入库) AS 入库,SUM(出库) AS 出库,SUM(上月结存+入库-出库) AS 本月结存 FROM (SELECT 机型,IIF(类别="上月结存",数量,0) AS 上月结存,IIF(类别="入库",数量,0) AS 入库,IIF(类别="出库",数量,0) AS 出库 FROM [数据源$A1:D] WHERE 机型 IS NOT NULL) GROUP BY 机型 HAVING SUM(上月结存+入库-出库)<5
复制代码- SELECT 机型,SUM(IIF(类别="上月结存",数量,0)) AS 上月结存,SUM(IIF(类别="入库",数量,0)) AS 入库,SUM(IIF(类别="出库",数量,0)) AS 出库, SUM(IIF(类别="上月结存",数量,0))+SUM(IIF(类别="入库",数量,0))-SUM(IIF(类别="出库",数量,0)) AS 本月结存 FROM [数据源$] GROUP BY 机型 HAVING SUM(IIF(类别="上月结存",数量,0))+SUM(IIF(类别="入库",数量,0))-SUM(IIF(类别="出库",数量,0))<5
复制代码 |