Is it possible to count words in a memo field

  • Thread starter Thread starter dbl
  • Start date Start date
D

dbl

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Try using dcount with a wild card (Like + *)

DCount("*","[TableName]","[FieldName] Like '*Invoice Chased*'")
 
Sorted thanks, for the help and quick response.
Bob
Ofer Cohen said:
Try using dcount with a wild card (Like + *)

DCount("*","[TableName]","[FieldName] Like '*Invoice Chased*'")

--
Good Luck
BS"D


dbl said:
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
Click to expand...
Click to expand...
 
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?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top