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