 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2007Is it possible to count words in a memo field
Hi is it possible to count the number of times the words "Invoice Chased" has been entered in a memo field? If it is how do I go about it? Thanks Bob Where: MField is the name of your memo filed SField is the search string SFieldCount is the number of occurances of the search string SFieldCount = (Len([MField]) - Len(Replace([MField], SField, ""))) / Len (SField) You're replacing the search string with a zero length string, comaparing the length of the memo field before and after the replacement(s) then dividing the difference by the length of the search string  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 dddddddddddddddddddddddddddddd > Where: > [quoted text clipped - 9 lines] > length of the memo field before and after the replacement(s) then dividing > the difference by the length of the search string kan ik niks aan doen > Where: > [quoted text clipped - 9 lines] > length of the memo field before and after the replacement(s) then dividing > the difference by the length of the search string Try using dcount with a wild card (Like + *) DCount("*","[TableName]","[FieldName] Like '*Invoice Chased*'") SignatureGood Luck BS"D > Hi is it possible to count the number of times the words "Invoice Chased" > has been entered in a memo field? If it is how do I go about it? > > Thanks Bob Sorted thanks, for the help and quick response. Bob > Try using dcount with a wild card (Like + *) > [quoted text clipped - 4 lines] >> >> Thanks Bob Just out of curiosity, were you trying to count the times this phrase appeared in the memo field of one record, or of all records in the table? SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.