Sergey,

Thanks! This works just the way I want.

If we can count on any one person to come through, it seems we can count on you 99.99999...9% of the time. In my younger days, I might have come up with the solution....and maybe not. The memory ain't what it used to be:)

Dale


>Dale,
>
>Try

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