Microsoft KB Archive/96902

{|
 * width="100%"|

PRA: StDevP with All NULL Records Returns #ERROR
'Article ID: Q96902

Creation Date: 30-MAR-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access version 1.0

SYMPTOMS

When the StDevP function is applied to a database containing only NULL records, The error message &quot;#ERROR&quot; results. This problem does not occur with the StDev function.

RESOLUTION

Make sure that at least one record of a database where the StDevP function is used contains a non-NULL value.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem was corrected in Microsoft Access version 1.1.

MORE INFORMATION

StDevP and StDev are functions that return estimates of the standard deviation for a population or a population sample, respectively.

Steps to Reproduce Behavior

  Create and save the following table: Table: Table1 -     FieldName: A         DataType: Text FieldName: B        DataType: Number Default Value: (blank)  View the Table1 table in Datasheet view. Add several records to the table, entering text in field A. Do not enter anything in field B for any of the records.  Create a new unbound form with the following text box: Object: Text box ControlName: Field0 ControlSource: =DStDevP(&quot;B&quot;,&quot;Table1&quot;)  View the form in Form view.

In Microsoft Access version 1.0 you will receive a &quot;#ERROR&quot; error message. In Microsoft Access version 1.1 you will receive NULL.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00

KBCategory: kbprg

KBSubcategory: PgmOthr