Re: Incorporating subquery into A query by SELECT

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

Hi,

missing a coma.


( Nz([200407], 0) + Nz([200408], 0) + Nz([200409], 0) + Nz([200410], 0) )
AS Numerator,
(4+ IsNull([200407]) + IsNull([200408]) + IsNull([200409]) +
IsNull([200410]) AS Denominator ,
Numerator / iif(( 0=Denominator, Null, Denominator) AS myAverage


I assumed you used Jet.

Vanderghast, Access MVP


.

Relevant Pages

  • Re: Conflicting needs for __init__ method
    ... single integer, another Rational instance, and perhaps floats, Decimal ... And when initializing from a pair of integers---a numerator ... sure that the denominator is positive. ... like negation or raising to a positive integer power, ...
    (comp.lang.python)
  • Re: infinite product
    ... This result generalizes to products with an arbitrary number of numerator and denominator terms. ... Note that this does not always give interesting formulae, since both sides may be zero because of poles of Gamma. ... It is for this reason that it is advisable to keep x in formula. ...
    (sci.math)
  • Re: Convert decimal to fraction string
    ... You can specify the maximum denominator to use in the ... Dim GCD As Long ... Dim TopNumber As Long ... Dim Numerator As Long ...
    (microsoft.public.vb.general.discussion)
  • Re: ga10- Integers found that form the sqrt(2) or transcendental numbers.
    ... the numerator and the denominator have the same number of decimal places. ... decimal comma to construct the integers until you have no comma (the limit of the sequence). ...
    (sci.math)
  • Re: Invalid setting in TransferFcn block G for parameter Denominator
    ... Most Simulink parameters are stored as strings, so you need: ... set_param(Ghandle, 'Numerator', 'Gnum'); ... set_param(Hhandle, 'Denominator', 'Hden'); ... The analog block is a TransferFcn block and the digital block is a Discrete Filter. ...
    (comp.soft-sys.matlab)