Summarizing quantities by Part Number

[Deb]

This query is working, but I'd like to "summarize" the quantities by
"PartNo". How do I go about doing that?

SELECT DISTINCTROW sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo, sqry_Inventory.Serial, sqry_Inventory.Building,
Sum(sqry_Inventory.[Updated Qty]) AS [Sum Of Updated Qty],
Sum(sqry_Inventory.UnitCost) AS [Sum Of UnitCost]
FROM sqry_Inventory
WHERE (((sqry_Inventory.Program)=[Enter Program]))
GROUP BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo, sqry_Inventory.Serial, sqry_Inventory.Building
ORDER BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo;

 

[Duane Hookom]

How about:

SELECT sqry_Inventory.PartNo,
Sum(sqry_Inventory.[Updated Qty]) AS [Sum Of Updated Qty],
Sum(sqry_Inventory.UnitCost) AS [Sum Of UnitCost]
FROM sqry_Inventory
WHERE (((sqry_Inventory.Program)=[Enter Program]))
GROUP BY sqry_Inventory.PartNo;

 

[Deb]

Thanks. I'll give it a try!

How about:

SELECT sqry_Inventory.PartNo,
Sum(sqry_Inventory.[Updated Qty]) AS [Sum Of Updated Qty],
Sum(sqry_Inventory.UnitCost) AS [Sum Of UnitCost]
FROM sqry_Inventory
WHERE (((sqry_Inventory.Program)=[Enter Program]))
GROUP BY sqry_Inventory.PartNo;

--
Duane Hookom
Microsoft Access MVP

This query is working, but I'd like to "summarize" the quantities by
"PartNo". How do I go about doing that?

SELECT DISTINCTROW sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo, sqry_Inventory.Serial, sqry_Inventory.Building,
Sum(sqry_Inventory.[Updated Qty]) AS [Sum Of Updated Qty],
Sum(sqry_Inventory.UnitCost) AS [Sum Of UnitCost]
FROM sqry_Inventory
WHERE (((sqry_Inventory.Program)=[Enter Program]))
GROUP BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo, sqry_Inventory.Serial, sqry_Inventory.Building
ORDER BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo;

 

[John W. Vinson]

This query is working, but I'd like to "summarize" the quantities by
"PartNo". How do I go about doing that?

If you mean that you want PartNo to be the grouping level, without breaking it
down by serial or building, just don't include those fields in the query:


SELECT DISTINCTROW sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo,
Sum(sqry_Inventory.[Updated Qty]) AS [Sum Of Updated Qty],
Sum(sqry_Inventory.UnitCost) AS [Sum Of UnitCost]
FROM sqry_Inventory
WHERE (((sqry_Inventory.Program)=[Enter Program]))
GROUP BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo
ORDER BY sqry_Inventory.Program, sqry_Inventory.Division,
sqry_Inventory.PartNo;