Re: #Num! Error

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/01/04 

Date: Thu, 2 Sep 2004 01:02:18 +0800

Use IIf() to test for zero in the divisor:
=IIf([RackTodayAnalysis] = 0, 0,
    DSum("[TransientRackRate]","[qryRoomsDaily]")/[RackTodayAnalysis]) 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Crown Royal" <CrownRoyal@discussions.microsoft.com> wrote in message
news:7ED25B2A-134C-4377-9440-9F2F8F602085@microsoft.com...
>I have a report in which one part calculates the results from one field
> divided by another. When there is a number in the divisor, everthing is 
> fine,
> but when the divisor is zero (the dividend is always zero at that point as
> well), I get the Num error.  The control source for this control is:
> =DSum("[TransientRackRate]","[qryRoomsDaily]")/[RackTodayAnalysis]
> I have tried to add an Iff to it, but I guess "And" is not what I need. 
> Thx
> for any help
>
> Eric

Relevant Pages

  • #Num! Error
    ... When there is a number in the divisor, everthing is fine, ... but when the divisor is zero (the dividend is always zero at that point as ... The control source for this control is: ...
    (microsoft.public.access.reports)
  • Re: Question about divisors of zero
    ... I would like to know whether divisor of zero(in any of the systems ... been useful in explaining some physical phenomena or has it been more ... In physics, all over the place, you use matrices. ... The rings of matrices are chock-full of zero divisors. ...
    (sci.math)
  • Re: Interesting math
    ... infinite number for that reason. ... divisor approaches zero the result grows larger and larger. ... dividend is constant. ...
    (alt.usage.english)
  • Re: Expression too complex Error
    ... You'll need to decide what number to use in your average when the divisor is ... zero as the result if the divisor is zero: ... <MS ACCESS MVP> ... FROM TestTable AS T1 INNER JOIN ActualTable AS E1 ON ...
    (microsoft.public.access.queries)
  • Re: Dividing Power Series
    ... at least for z in a disk where both series converge ... If the divisor has a zero at the origin, then you get a Laurent series ... -Greg Magarshak ...
    (sci.math)