Tuesday, March 27, 2012

Basic problem (calculating nulls)

Hi Everyone,

I have a basic problem, am calculating two fields, which works fine when both have values (0's included), however when there is nothing populated in the field I don't get a result.

Therefore how do I default a null to a zero so this can be calculated?

Thanks all...Hi

if isnull(myfiel) then
myvar:=0|||Thank you very much will give that a go now.

No comments:

Post a Comment