Calculating or Adding Values that are 0

[blanch2010]

I have three fields that I need to total. When i do run the total nothing
appears because one of the fields has a 0 value.

The expression is not counting 0 values, how do I work around this?

 

[KARL DEWEY]

Is the value actually zero or Null?
If it is null then use the NZ function like this --
Nz([Field1], 0) + Nz([Field2], 0) + Nz([Field3], 0)

 

[blanch2010]

Hi Karl.


The value is actually zero until someone updates the record. So do I use
what you gave me below?

Thanks
Don

Is the value actually zero or Null?
If it is null then use the NZ function like this --
Nz([Field1], 0) + Nz([Field2], 0) + Nz([Field3], 0)

--
Build a little, test a little.

I have three fields that I need to total. When i do run the total nothing
appears because one of the fields has a 0 value.

The expression is not counting 0 values, how do I work around this?

 

[blanch2010]

That's working! Thank You again Karl.

Don

Hi Karl.


The value is actually zero until someone updates the record. So do I use
what you gave me below?

Thanks
Don

Is the value actually zero or Null?
If it is null then use the NZ function like this --
Nz([Field1], 0) + Nz([Field2], 0) + Nz([Field3], 0)

--
Build a little, test a little.

I have three fields that I need to total. When i do run the total nothing
appears because one of the fields has a 0 value.

The expression is not counting 0 values, how do I work around this?