Totaling Fields
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
"Ananth" wrote in message
...
I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz([Table]!Jan,0)+ nz([Table]!Feb,0)... nz([Table]!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
|