Re: Summing when one value is NULL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sue Compelling

This is definition of NZ Function, This is not the proper way to tell
someone to search in help. This is the best way, I assume. This is Microsoft
way to exaplin thing in incomplete format.

Nadeem

Nz Function
You can use the Nz function to return zero, a zero-length string (" "), or
another specified value when a Variant is Null. For example, you can use this
function to convert a Null value to another value and prevent it from
propagating through an expression.

Nz(variant, [valueifnull])

=(Nz([211 Service Enquiries], 0)

In your case u are telling this function that return zero in case ([211
Service Enquiries] is null value.

U can also modify this function in case u want return some Text value when u
donot want to use this function in any formula like

=(Nz([211 Service Enquiries], " Your Value is Null")

Thanks

"Sue Compelling" wrote:

> Brilliant Tina - that worked.
>
> Tell me - what is the formula 'saying' - ie what the Nz all about [I'm an
> Access newbie]
> --
> Sue Compelling
>
>
> "tina" wrote:
>
> > try
> >
> > =(Nz([211 Service Enquiries], 0) + Nz([Reception Services], 0) + Nz([Wrong
> > Number], 0) + Nz([Hang Up / Hoax / Nuisance], 0))
> >
> > hth
> >
> >
> > "Sue Compelling" <SueCompelling@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:B9201526-886A-43FA-ACC0-91E36D4E0C13@xxxxxxxxxxxxxxxx
> > > Hi
> > >
> > > I have the following formula, which works when all fields for a date range
> > > are filled in. However, if there were no calls of a particular type for
> > the
> > > period, ACCESS returns a blank. How do I get ACCESS to 'recognise' the
> > NULL
> > > value and add up the rest of the fileds?
> > >
> > > =([211 Service Enquiries]+[Reception Services]+[Wrong Number]+[Hang Up /
> > > Hoax / Nuisance])
> > >
> > > TIA
> > > --
> > > Sue Compelling
> >
> >
> >
.

Relevant Pages

  • Re: Annotated Einstein Clock
    ... > [snipp what Sue doesn't address] ... > "division by zero". ... > Let there be a clock A on the ground at equator. ... > Let the axle rotate N times during one Earth rotation. ...
    (sci.physics.relativity)
  • Re: Three Ring Circus
    ... >>> reference to velocity addition for a rotating system. ... > My apology Sue, ... "In agreement with experience we further assume the quantity ... The distance from A to A is zero. ...
    (sci.physics.relativity)
  • RE: if formulas
    ... I put zero in the formula to give a zero results. ... "Sue" wrote: ... "Mike Rogers" wrote: ... That works except my data in Cell F2 is coming in as text from data source, ...
    (microsoft.public.excel.misc)
  • Re: Karl Rove Copyright Question About Citing Blogs Who Cite Others [Blurbs]
    ... Zero wrote: ... Or write your own excoriation of Rove. ... No one is going to sue you. ...
    (misc.writing)
  • Re: British workmanship?
    ... 'proper' job, he's threatening a) to sue me. ... neighbours that I wont pay my debts, and c) to come and do the job when I'm ...
    (uk.legal)