Mode Average Function

[Chris Sheppard]

All,

I am using Access 97 and want to find the MODE of a group
of records for (in this case) delivery time. I already
can obtain the mean using the Avg function.

Is there something simliar, or a technique, that I can use
to obtain the Mode for the records?

TIA,

Chris

 

[John Nurick]

Hi Chris,

Try something like

SELECT TOP 1 DeliveryTime, Count(DeliveryTime) AS Instances
FROM MyTable
GROUP BY DeliveryTime
ORDER BY Count(DeliveryTime) DESC;