ACC: How to Calculate Row-Level Statistics (95/97) (189584)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q189584 Advanced: Requires expert coding, interoperability, and multiuser skills.
SUMMARY
Although Microsoft Access has several built-in functions that enable you to
perform statistical analysis across records, it does not have a built-in
function to perform statistical analysis across multiple columns within a
single row. This article shows you how to create several sample
user-defined functions that you can use to get row-level statistics in
Microsoft Access version 95 and 97.
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.
REFERENCES
For more information about database normalization, please see the following
article in the Microsoft Knowledge Base:
100139
ACC: Database Normalization Basics
For more information about parameter arrays, search the Microsoft Access
Help Index for "parameter arrays."
For more information about the For...Each syntax, search the Microsoft
Access Help Index for "For Each...Next Statement."
You may find more information on statistical formulae by searching the Help
Index of Microsoft Excel for "statistical functions."
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB189584 |
---|
|