Mode Average Function

  • Thread starter Thread starter Chris Sheppard
  • Start date Start date
C

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
 
Hi Chris,

Try something like

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