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 monthlyNext: Automatically add new record