SELECT Order_Date, Sum(OB_Amount_EUR) AS OB_Amount_EUR之总计, Sum(IIf(Now()-Order_Date<=60,OB_Amount_EUR,0)) AS [0-60天], Sum(IIf(Now()-Order_Date>60,OB_Amount_EUR,0)) AS 大于60天 FROM [Sheet1$] GROUP BY Order_Date HAVING Sum(OB_Amount_EUR)<>0
SELECT Order_Date, Sum(OB_Amount_EUR) AS OB_Amount_EUR之总计, Sum(IIf(Now()-Order_Date<=60,OB_Amount_EUR,0)) AS [0-60天], Sum(IIf(Now()-Order_Date>60,OB_Amount_EUR,0)) AS 大于60天 FROM [Sheet1$] GROUP BY Order_Date HAVING Sum(OB_Amount_EUR)<>0