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?

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.


"blanch2010" wrote:

> 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?

Hi Karl.


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

Thanks
Don

"KARL DEWEY" wrote:

> 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.
> 
> 
> "blanch2010" wrote:
> 
> > 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?

That's working!  Thank You again Karl.

Don

"blanch2010" wrote:

> Hi Karl.
> 
> 
> The value is actually zero until someone updates the record.  So do I use 
> what you gave me below?
> 
> Thanks
> Don
> 
> "KARL DEWEY" wrote:
> 
> > 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.
> > 
> > 
> > "blanch2010" wrote:
> > 
> > > 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?