>The iif() function (below)fails with .null. set as the result of the true condition, but works fine from the command window.
>
>I can replace the .null. with a number and it works fine.

>SELECT	ALL;
>        quotes.mdesc                   AS QMDESC,;
>        wip.manovrde                   AS WMANOVRDE,;
>        produtn.prodno                 AS PPRODNO,;
>
>        iif(val(wip.wtr9)=0,.null.,val(wip.wtr9)) AS WWTR9,;

>This is in the FoxFire Report Writer. I need all the 0's to appear as nulls in order to calculate averages accurately.

Dale,

Try

iif(val(wip.wtr9)=0, VAL(null),val(wip.wtr9)) AS WWTR9,;