I have this bug in my query that really bugs me. The thing is one of my fields in the query is supposed to be a sum of two fields in a table, i.e
Variable 3: [Variable 1]+[Variable 2]
This works just fine, except for one case. When the first variable happens to be null (i.e not zero but missing value) , variable 3 also becomes null even if Variable 2 is not equal to null.
I find this very puzzling and any help to solve this is of course very welcome. Strangely enough this does not happen when variable 2 is null and variable 1 is not equal to null.
Variable 3: [Variable 1]+[Variable 2]
This works just fine, except for one case. When the first variable happens to be null (i.e not zero but missing value) , variable 3 also becomes null even if Variable 2 is not equal to null.
I find this very puzzling and any help to solve this is of course very welcome. Strangely enough this does not happen when variable 2 is null and variable 1 is not equal to null.