hi ,
i try as under,it works but not every things,
i have year1=2004,and all months must field still replace with 1

m.no=no
replace still with 1 in 'tab2' for amount <= 0 or ((month1<MONTH(DATE()) and year1<=YEAR(DATE()))) AND no==m.no

thanks.

>

>replace still with 1 in 'tab2' for (amount <= 0 or (month1<MONTH(DATE()) and year1<=YEAR(DATE()))) AND no==m.no
>

>
>;o)