Need SUM Formula

[Crystalfire]

I have a Centura Report that list the Hours of assembly of a work order. The report shows these hours by by each part number used for that particular work ordr. I need a formula that would sum up the hours for the total work order. Thanks!

 

[JimboNWUK]

Not sure what the exact SQLBase syntax is but I assume it is similar to Oracle:

SELECT WORK_ORDER_ID,
SUM(HOURS)
FROM WORK_TABLE
GROUP BY WORK_ORDER_ID

would do it in Oracle assuming that WORK_ORDER_ID is repeated in the WORK_TABLE for each assembly.

Jm.