>hi all,
>
>i need help to count again the same field as below
>
>

>SELECT office , department,count(office) as total_cfil && and  count(office) as sub-total where flg="1" and newfield have( total_cfil -sub-total) ;
>from new1 ;
>group by department,office INTO table mucurt
>

>
>thanks

Mohammed,

You may try (VFP9 only - uses derived table)

select *, total_cfil -SubTotal as NewField from (select Office, Department, ;
Count(Office) as Total_cFil, sum(iif(Flg=1, 1,0)) as SubTotal from New1 ;
group by department,office) X into table MuCurt