Totaling Fields

[Ananth]

I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz(

!Jan,0)+ nz(

!Feb,0)….. nz(

!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance

 

[Fred Smith]

What does the function "nz" do?

If it's your equivalent of the Round function, that's your problem. You are
rounding your results to zero decimal places. Simply take it out.

 

[Dave Peterson]

You may want to copy directly from the formula bar and paste into your message,
too.

I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz(

!Jan,0)+ nz(

!Feb,0)….. nz(

!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance

 

[Ananth]

Nz function is applied to return zero, a zero-length string (" "), or
another specified value when a Variant is Null.It has nothing to do with
round function.

What does the function "nz" do?

If it's your equivalent of the Round function, that's your problem. You are
rounding your results to zero decimal places. Simply take it out.

--
Regards,
Fred

I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz(

!Jan,0)+ nz(

!Feb,0)... nz(

!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance