Calculate mode value of a list of words.

[JWPratt8]

Hi all,

I'm trying to show the modal value of a column in a query that only has text in, not numbers. I want to present this in a text box in a report.

My report already has a query as its record source that only shows data for a given year and given month, these are chosen using parameters created in the query. Thus all I need to figure out is how to show the modal value for the column "Categories" on the report somehow.

Here are my parameters:

Query: [Formula Query]
Column: [Categories]

Hopefully there is a way to make this possible.

Thanks,

J.

 

[plog]

If you can provide some sample data and what the result should be I can help specifically. Otherwise in general I would create a COUNT query to determine the number of times certain values appear in a list and get my mode from there:

SELECT Categories, COUNT(Categories) AS RecordCount FROM YourTableNameHere;