Are you trying to find the Median (value of the middle item in the list) or

the Mode (the value that repeats most often)?

--

Wayne Morgan

MS Access MVP

<dm******@hotmail.com> wrote in message

news:11**********************@o13g2000cwo.googlegr oups.com...

I know there is an equation to come up with this but I can't think of

it.

I have to enter 3 different measurements an example below:

15.25

15.25

15.00

I need this to return the average of the three like this 15.25

I used the following but I get the average of the sum:

([ab1] + [ab2] + [ab3])/3 this will equal 15.17

I need it to return 15.25 It's probably a min/max function but I need

some help

Thanks