Sum duplicate lines in a table

[Neil]

I have a table which contains a list of products soted by poduct name.
Against each product there is a stock quantity, each Item may appear more
than once.
I want to be create a query which will give me a list of the products, but
with only one entry per item, with a total quantity for each item.

Is this possible?

Thanks

 

[PieterLinden via AccessMonster.com]

I have a table which contains a list of products soted by poduct name.
Against each product there is a stock quantity, each Item may appear more
than once.
I want to be create a query which will give me a list of the products, but
with only one entry per item, with a total quantity for each item.

Is this possible?

Thanks

Use a totals query

SELECT ProductID, ProductName, Sum([StockQty])
FROM MyTable
GROUP BY ProductID, ProductName
ORDER BY ProductID, ProductName