Problem with query result

[Gil D.]

Hello,

I have a query with 2 sub queries.
Each query returns one value.
My query should sum these values and display the sum.

For example:
sub query 1 returns 5
sub query 2 returns 10
my query should display 15

My problem is when one query returns NULL.

For example:
sub query 1 returns NULL
sub query 2 returns 10
my query should display NULL

How can I solve this in the select statement ?

Thank you
Gil D.

[Tom van Stiphout]

On 19 Jun 2006 17:31:49 -0700, "Gil D." <sn********@walla.com> wrote:

That's exactly what it will do.
Note that any arithmetic with Null will result in Null.

If you think your queries don't return Null, test each one with
?IsNull(DLookup(...)) in the immediate window. Perhaps one of them is
returning "" rather than Null.

-Tom.

Hello,

I have a query with 2 sub queries.
Each query returns one value.
My query should sum these values and display the sum.

For example:
sub query 1 returns 5
sub query 2 returns 10
my query should display 15

My problem is when one query returns NULL.

For example:
sub query 1 returns NULL
sub query 2 returns 10
my query should display NULL

How can I solve this in the select statement ?

Thank you
Gil D.

[Gil D.]

Hello,

Thank you for your help.
My query returns NULL sometimes.
I found that the NZ(MyQueryResult,0) function can solve my problem
(returns 0 instead of NULL).

Thank you
Gil D.

[Tom van Stiphout]

On 20 Jun 2006 01:35:58 -0700, "Gil D." <sn********@walla.com> wrote:

You wrote:
my query should display NULL

You meant:
my query should display 0

-Tom.

Hello,

Thank you for your help.
My query returns NULL sometimes.
I found that the NZ(MyQueryResult,0) function can solve my problem
(returns 0 instead of NULL).

Thank you
Gil D.