ACC: How to Exclude Zero Values When You Calculate Averages (109364)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q109364
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
When you use the Avg() function in a report to average a set of values, the
function uses records that contain zero values in the calculation. In some
cases you may not want to include records with zero values in a
calculation.
This article includes two examples of how to calculate an average for all
the non-zero values in a set by counting the number of non-zero values in
the set of values and then using that total with a running sum
calculation.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
NOTE: Visual Basic for Applications is called Access Basic in Microsoft
Access versions 1.x and 2.0. For more information about Access Basic,
please refer to the "Introduction to Programming" manual in Microsoft
Access version 1.x or the "Building Applications" manual in Microsoft
Access version 2.0.
REFERENCES
For more information about the Avg() function, search the Help Index for
Avg function.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming kbusage KB109364 |
---|
|