How do I calculate min and max values from columns in same row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to get a min and max value from differnt fields and to also
check if it is with in a certain range.
example>
Race: time 1, time 2,...- 48 MIN MAX All Qualify (range .5 - 4.5)
Race 1 3.6 4.0 ... 3.6 4.0 Yes
Race 2 5.0 3.2 ... 3.2 5.0 No
etc...
 
See the MinOfList() and MaxOfList() functions here:
http://allenbrowne.com/func-09.html

A better solution would be to build a relational structure where each time
is a record of its own, not many repeating columns in the one table. The
table would have fields such as:
RaceID which race this record is for
EntrantID whose time this is in this race
RaceTime the time for this entrant in this race.
 
Back
Top