dcsimg
Results 1 to 2 of 2

Thread: selecting and counting a word in memo in access

  1. #1
    Join Date
    Apr 2009
    Posts
    1

    selecting and counting a word in memo in access

    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

  2. #2
    Join Date
    Feb 2009
    Posts
    17
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •