access thread: nz([value], 0) function
Message #1 by "wambui njoroge" <kagdw189@b...> on Tue, 24 Sep 2002 01:25:58
|
|
I have the following code to convert null values to zero.
TotalGRE = Nz([GREV], 0) + Nz([GREQ], 0) + Nz([GREA], 0)
I'm still getting null values for TotalGRE if one of the values is null.
Is there something wrong with my code?
Thanks in advance for your help.
Wambui.
Message #2 by "dave sharpe" <davesharpe2@c...> on Mon, 23 Sep 2002 21:07:13 -0400
|
|
Wambui.
nz() does not return a numeric value, try the following
TotalGRE = val(Nz([GREV], 0)) + val(Nz([GREQ], 0)) +val( Nz([GREA], 0))
Dave
----- Original Message -----
From: "wambui njoroge" <kagdw189@b...>
To: "Access" <access@p...>
Sent: Tuesday, September 24, 2002 1:25 AM
Subject: [access] nz([value], 0) function
> I have the following code to convert null values to zero.
>
> TotalGRE = Nz([GREV], 0) + Nz([GREQ], 0) + Nz([GREA], 0)
> I'm still getting null values for TotalGRE if one of the values is null.
> Is there something wrong with my code?
>
> Thanks in advance for your help.
>
> Wambui.
>
Message #3 by "wambui njoroge" <kagdw189@b...> on Tue, 24 Sep 2002 23:33:23
|
|
Dave,
The code now works. Thanks a lot.
> Wambui.
nz() does not return a numeric value, try the following
TotalGRE = val(Nz([GREV], 0)) + val(Nz([GREQ], 0)) +val( Nz([GREA], 0))
Dave
----- Original Message -----
From: "wambui njoroge" <kagdw189@b...>
To: "Access" <access@p...>
Sent: Tuesday, September 24, 2002 1:25 AM
Subject: [access] nz([value], 0) function
> I have the following code to convert null values to zero.
>
> TotalGRE = Nz([GREV], 0) + Nz([GREQ], 0) + Nz([GREA], 0)
> I'm still getting null values for TotalGRE if one of the values is null.
> Is there something wrong with my code?
>
> Thanks in advance for your help.
>
> Wambui.
>
|
View Cart
