合并相同产品的数据 [已解决]

zhanguoru

不好意思，不知为什么我上传不了附件：
新建查询：

SELECT tbl发货_2.[Planned Shipment Date], tbl发货_2.[Document No_], tbl发货_2.[Delivery Item No_], First(tbl发货_2.[Line No_]) AS [Line No_OfFirst], Sum(tbl发货_2.Quantity) AS QuantityOfSum, tbl发货_2.[Sales Order No_], First(tbl发货_2.Key) AS KeyOfFirst
FROM tbl发货_2
GROUP BY tbl发货_2.[Planned Shipment Date], tbl发货_2.[Document No_], tbl发货_2.[Delivery Item No_], tbl发货_2.[Sales Order No_];