SQL help

[The Rook]

I have created a query in MS Access as below:

SELECT dbo_WOCLOCK.Works_Order, dbo_WOCLOCK.Operation,
dbo_WOCLOCK.Resource_Code_Plann, dbo_WOCLOCK.Resource_Code_Actua,
dbo_VIEW_WO_OPS.Op_Time_in_sec, dbo_VIEW_WO_OPS.Actual_Finish_Date,
dbo_WOCLOCK.Operation_Time
FROM dbo_WOCLOCK INNER JOIN dbo_VIEW_WO_OPS ON (dbo_WOCLOCK.Works_Order =
dbo_VIEW_WO_OPS.Works_Order_No) AND (dbo_WOCLOCK.Operation =
dbo_VIEW_WO_OPS.Operation_No);

I am wanting to add together dbo_WOCLOCK.Operation_Time where multipule
dbo_WOCLOCK.Works_Order, dbo_WOCLOCK.Operation match.

For example:

dbo_WOCLOCK.Works_Order = 1234 & dbo_WOCLOCK.Operation match = 70 &
dbo_WOCLOCK.Operation_Time = 5000

dbo_WOCLOCK.Works_Order = 1234 & dbo_WOCLOCK.Operation match = 70 &
dbo_WOCLOCK.Operation_Time = 8000

the query would result:

dbo_WOCLOCK.Works_Order = 1234 & dbo_WOCLOCK.Operation match = 70 &
dbo_WOCLOCK.Operation_Time = 13000

How can this be achieved?

Regards

 

[Tom van Stiphout]

On Wed, 11 Feb 2009 04:23:01 -0800, The Rook

I think you want a Totals query like this:
select Operation, sum(OperationTime)
from myTable
group by Operation

Use the Sigma button to switch to Totals queries.

-Tom.
Microsoft Access MVP