Re: =Abs Zero error in my code?
- From: "Wayne Morgan" <comprev_gothroughthenewsgroup@xxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 15:48:41 -0500
Where you may be having a problem is that the equation Null>0 returns Null,
not false. Also, once one of the values returns Null, the value of the
addition will be Null. The general rule is Null will propagate through an
equation. Try wrapping each field in Nz().
=Abs((Nz([Additional Sample],0)>0)+(Nz([Additional Sample
#2],0)>0)+(Nz([Additional Sample #3],0)>0)+(Nz([Additional Sample
#4],0)>0)+(Nz([Additional Sample #5],0)>0)+(Nz([Additional Sample
#6],0)>0)+(Nz([Additional Sample #7],0)>0)+(Nz([Additional Sample
#8],0)>0)+(Nz([Additional Sample #9],0)>0)+(Nz([Additional Sample
#19],0)>0))
--
Wayne Morgan
MS Access MVP
"Dave Elliott" <dave@xxxxxxxxxxxxxxxxxx> wrote in message
news:VHRbe.1184$m85.802@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I need this formula to show a 0 if if the values equal 0
> right now if it is > than 0 it works but not if less than 1
> then I get #num! error message
>
>
>
>
>
>
> =Abs(([Additional Sample]>0)+([Additional Sample #2]>0)+([Additional
> Sample #3]>0)+([Additional Sample #4]>0)+([Additional Sample
> #5]>0)+([Additional Sample #6]>0)+([Additional Sample #7]>0)+([Additional
> Sample #8]>0)+([Additional Sample #9]>0)+([Additional Sample #19]>0))
>
.
- References:
- =Abs Zero error in my code?
- From: Dave Elliott
- =Abs Zero error in my code?
- Prev by Date: RE: Delete message
- Next by Date: RE: Hiding Report
- Previous by thread: =Abs Zero error in my code?
- Next by thread: Re: =Abs Zero error in my code?
- Index(es):
Relevant Pages
|
