Thanks Sergey

That sounds right. I'll check it tomorrow and let you know.

Mo

>Yes, you're correct that IIF() causes the problem because it returns different numeric format in each case. You can try

ROUND(IIF((.NOT.cmflag.AND.cmpro),(grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0.0000),0) AS ale_pro,;

The goal is to get the same numeric format regardless if condition in IIF() is false or true.
>
>>I noticed that I start getting teh error after I added the IIF() in the second views.
>>
>>OK, the select part only, View 1
><snip>>
>

>>View 2
>>-------
>>
>>SELECT IIF((cmflag.AND..NOT.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_cur,;
>>  IIF((cmflag.AND.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_imp,;
>>  IIF((.NOT.cmflag.AND.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_pro,;
>>  IIF((.NOT.cmflag.AND..NOT.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_non,;
>>  ROUND(cmfirstweight/100,2)*ale_max AS cmfinalweight, Q_risk_ale3.*;
>> FROM ;
>>     VIew1;
>> ORDER BY VIew1.vulname, VIew1.grpname,;
>>  VIew1.thrname, VIew1.cmref
>