Microsoft KB Archive/48966

From BetaArchive Wiki

Microsoft Knowledge Base

File: Maximum or Minimum Return Zero in a Report

Last reviewed: October 27, 1994
Article ID: Q48966

Summary:

The method by which Microsoft File calculates the Minimum and Maximum in the summary report differs from the method used for the Count, Average, and Standard Deviation (Std. Dev.) functions.

With Count, Average, and Std. Dev., File uses only records with data in the field being calculated. With Minimum and Maximum, File uses all records.

For example, if there are four records, three with data in field A and one with field A blank, the Count of field A returns a "3".

Using the same four records as above, if all numbers in field A are positive, the Minimum of field A returns a "0" (zero). Note that blanks are seen as zeros for the purpose of Maximum and Minimum.


Additional reference words:

KBCategory: kbusage
KBSubcategory:


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" 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.

Last reviewed: October 27, 1994
©1997 Microsoft Corporation. All rights reserved. Legal Notices.