Word count? Keywords?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a memo field (called "ProblemDescription") in which we paste the text
of a client's request. We need to find out which words are appearing most
frequently ("keywords"). Is there a way to ask Access to do a word count on
unidentified words to determine which words are most common?
Thanks!!
 
Hi Laurie,

I would use the Split function on the memo field to produce an array of the
words. Then setup 2 arrays where each unique word would be saved in one
array and the count in the other one. Those arrays can be compared to your
keyword list.

Peter
 
Back
Top