How do I get Totals of rows values in query?

[Azad, DH, BD]

I want to get the Total from the purchase table as bellow:

Purchase : Total:
MName Qty Date MName Qty
Date Range
====================== ======================
Bricks 500 5/15/2008 ===> Bricks 6500
5/15/08 -5/31/2008
Cement 50 5/16/2008 Cement 200
5/15/08 -5/31/2008
Bricks 5600 5/17/2008
Bricks 400 5/19/2008
Cement 55 5/19/2008
Cement 95 5/16/2008

 

[John W. Vinson]

On Tue, 27 May 2008 22:52:00 -0700, Azad, DH, BD <Azad, DH,

I want to get the Total from the purchase table as bellow:

Purchase : Total:
MName Qty Date MName Qty
Date Range
====================== ======================
Bricks 500 5/15/2008 ===> Bricks 6500
5/15/08 -5/31/2008
Cement 50 5/16/2008 Cement 200
5/15/08 -5/31/2008
Bricks 5600 5/17/2008
Bricks 400 5/19/2008
Cement 55 5/19/2008
Cement 95 5/16/2008

Create a Query based on the table. Select only the MName and Qty fields.

Change it to a Totals query by clicking the Greek Sigma icon (looks like a
sideways M).

Leave the default "Group By" on the Total row for MName, and change it to Sum
on Qty.