Query to give Subtotals of field

[dinesh_ltjd]

Hi Sir,

I am very new to this access world. Before this I have a good knowledge of excel and basic vba for excel.
I am working in a database in which there is a table where i have following fields
PRODUCT ID QUANTITY
2801 40.00
2801 40.00
2801 40.00


2808 40.00
2808 40.00
2808 40.00
2808 40.00

Now I want output 'Product ID Wise quantity ordered'
PRODUCT ID QUANTITY
2801 120.00
2808 160.00
Just like we do Pivots in excel But i dont want to create a pivote view in acess.
Please guide if possible

Thanks
DG

[orange]

Consider a table - ltjd - with fields

ProductId, Quantity

a query such as

SELECT ltjd.ProductId
, Sum(ltjd.Quantity) AS SumOfQuantity
FROM ltjd
GROUP BY ltjd.ProductId;

will give the following result

ProductId	SumOfQuantity
2801	120
2808	160

[dinesh_ltjd]

Thank u sir for your help

I have used Total Query then Group By in Query Design Mode

Thanks Again