selecting and counting a word in memo in access

[nana_8265]

Hi, i want count a word in memo field and select this word...exmaple is i have this phrase :
"Microsoft Word is Microsoft's word processing software"
count(word) = 2
and select the two words..
can help me plz

[tattooedscorpdc]

port your data string into a list and use the " " (space) as your delimiter, Create a variable before the loop begins and set its value to zero. in your conditional statements within your loop if the word is found add 1 to the variable you declared befroe looping over the items in the list...

Hope this helps,

Larry Darrah
MS AE