MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Calculating or Adding Values that are 0

• Follow

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

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

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

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

3 Replies
217 Views

Similiar Articles:

7/24/2012 1:28:41 AM