Prev: Convert annual data to monthly
Next: Automatically add new record
From: blanch2010 on 2 Feb 2010 11:29
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?
From: KARL DEWEY on 2 Feb 2010 11:46
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?
From: blanch2010 on 2 Feb 2010 14:26
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?
From: blanch2010 on 2 Feb 2010 15:03
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?
 | 
Pages: 1
Prev: Convert annual data to monthly
Next: Automatically add new record