Please read my previous message. It explains all you've to do.

>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>