combining same values

S

spike

Having a braincramp....
i have a table

part qty
ab 2
ab 8

i would like a query to give me
part qty
ab 10

thank you for uncramping
 
J

John Spencer

SELECT Part, Sum(Qty) at TotalQty
FROM [YourTable]
GROUP BY Part

In the query grid (Design view)
-- Select View: Totals
-- Change Group By to Sum under the field Qty

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top