hi,
thank very much,
the 2 perfict lines works,
a bout sum i get stars ****

i open my report, go to report----title/summary--->summery band
i put myfield as tot_m....i think i must insert the function
i try as under

Sec2Str(sum(INT(CTOT(tot_m) - CTOT("00:00"))))&& error message sum.prg dose not exist

thanks.
m.qasem
thanks.

>Add 2 more columns to the query

...
>SUM(IIF(typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_m, ;
>SUM(IIF(typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_a ;
>...
>

After that you can create report variables for tot_m and tot_a in the and with calculation as SUM. You can reference those variables wrapped in Sec2str() in the fields in the summary band.
>
>
>>I'm sorry to bother you
>>I try to do it at my self, I fail
>> This code under it works,
>
><snip>