Calculating total and other

[Luong]

Hello All,

I want to create a report from a query that calculate the
total from each categories, total of categories excluding
one category and grand total.
The fields are: ToolID, Date, Stages, Time, where ToolID
is the key field, there are three stages where we record
the time in hours.
In my current report, I have the followings:
Stage = ASSEMBLY
ToolID Date Time
0100 9/2/03 10
0101 9/3/03 08
0102 9/3/03 12
Total: 30

Stage = CALIBRATION
ToolID Date Time
0105 9/4/03 05
0104 9/6/03 13
Total: 18

Stage = PART DELAY
ToolID Date Time
0105 9/4/03 05
0104 9/8/03 04
Total: 09

Grand Total: 57 Hours

I also would like to calculate the Total hours for
ASSEMBLY and CALIBRATION combined only. How do I do this?
Thanks

 

[Duane Hookom]

Assembly and Calibration only:
=Abs(Sum( [Time] * ([Stage]<>"Part Delay") ))
Total of all stages
=Sum([Time])