Help, Please. Finding the Mode

[Obsessive]

I've been messing around with the expression builder but cannot find the syntax to find the Mode - the # most often (most frequently) shown within a group of records. My field name is [Lead Time], I'm not sure if it's important, but it is a calculated field from a query.

(Lead Time: =[received]-[ordered])

.

 

[dhookom]

I suppose you could use multiple queries. One would group by the Lead Time field/column and count the occurrences. Then select the TOP 1 of this query sorted by the number of occurrences DESC.

Duane
MS Access MVP

 

[MichaelRed]

No need for multiple queries. Just the single aggregate count on grouped by value sorted desc top 1.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places