Is it possible to count words in a memo field

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
 
M

missinglinq via AccessMonster.com

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
 
O

Ofer Cohen

Try using dcount with a wild card (Like + *)

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

dbl

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...
 
M

missinglinq via AccessMonster.com

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?
 
Top