MS access query?

Question

how can i search using a query to find the most frequent result. i.e. search for the word that appears the most in a table.

i hope that makes sense.

thanks teef_au but that doesnt help.

i have no clue what the most frequently appeared word is. and searching each word and then counting how mny times it appers will take forever.

i need more help please!

Answer 1

I think you're going to have to export the contents of the table to a text file and then use a third-party word counting software app on the results. I haven't heard of one that does what you want, but I'm pretty sure you can't do it within Office.

Answer 2

I hope that the word you are looking for was entered by means of a fixed list like a drop down. So that there is no chance someone mis-spelled it, otherwise this will be difficult to do. Let's say you are looking for the word wonderful. In the criteria for that column in the query builder simply type in "wonderful" By placing the inverted commas, it will look for precisely that string.