Hi,

If you want a total of the sum(mat_amount) field you can compute the total using the following:


column total format 9999990

compute sum of total on report

select A.Work_item_code,A.work_description,sum(mat_amount) "total"
from mwebwork A, MWEBWORK B, mwebmatrix
where B.WORK_ENTITY_TYPE=4 and mat_work_id=B.work_id and mat_category between 2500 and 3999 and
mat_date between to_date('01-Dec-2000', 'DD-MON-YYYY') AND TO_DATE('10-DEC-2000', 'DD-MON-YYYY') AND A.WORK_ID=B.WORK_PAR6 AND A.WORK_LEVEL=6 GROUP BY A.WORK_ID, A.WORK_ITEM_CODE, A.WORK_DESCRIPTION;

clear computes


As for the time issue...Have you got the columns in the where clause indexed properly?
Hope this helps.

Let me know if it's what you're looking for...

Kind Regards

Moff