combining same values

  • Thread starter Thread starter spike
  • Start date Start date
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
 
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
..
 
Back
Top