ACC: How to Find Minimum or Maximum Value Across Fields of Record (182760)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q182760 SUMMARY
Advanced: Requires expert coding, interoperability, and multi-user skills.
Microsoft Access has no built-in functions that find the maximum or minimum
values of numbers across the fields of a record. This article shows you how
to create two custom functions that cycle through the values across fields
and return the minimum or maximum values of each record.
REFERENCES
For more information about creating custom functions, search the Help
Index for "custom functions", and then "Create a Custom Function."
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB182760 |
---|
|