Is it possible to select a minimum and maximum value from multiple fields in Access 2010?
Posted on 2014-10-16
I have eight fields that contain counts or percentages of loans made by institution and need to be able to determine which of the these fields has the lowest and highest values. Ideally, I would use a function like Min([field1], [field2], [field3], etc) to determine which field has the minimum value but no such functions exists in Access 2010. Each field contains values for a specific category so the values in all fields cannot be combined. The goal is to show, by institution, which fields have the lowest and highest values.
If someone can suggest a fairly easy way to determine the minimum or maximum value for a group of fields I would appreciate the advice.