For median, how to pick higher of two values, Access

V

VM

Does anyone know how to write Visual Basic for Access, so that in case of a
tie, the number picked for the median is the higher of two values? For
example, we do two-fold dilutions of antibiotics: .5, 1, 2, 4, 8, 16, 32,
etc. When the median is a tie between 8 and 16, we need to know how to tell
it to pick the higher of the two numbers. Any help would be much appreciated.
 
Top