Let's say I have a table named "answers" with a field named "answerText", and I collect survey data in this field. To analyze the data, I want to display a list of the 10 most common words used in the text in this field. For example I want a list like:
dissatisfied -- 1023
happy -- 826
I already built a solution, but I had to make a related table named "words". Every time an answer record is created, a group of "word" records are created, one for each word in the answer. Then I can just group (or subsummary) by word in a report.
But I'm wondering if there's a better way?