null + number = null

Y

Yair Sageev

Hello,

I have three calculated fields the first is a number that always is valid,
the second is the result of a sum query, and the third adds fields 1 and 2
together. The problem I am having is that if there are no records matching
in the dlookup sum query the value of that field is null, and the third
field does not display a number (which should simply be the value of the
first field).

I tried setting the default value of the 2nd field to 0, but it has no
effect.

Any ideas? Thanks in advance.
 
Top