Is it possible to count words in a memo field

[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

 

[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

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

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

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

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

 

[dbl]

Sorted thanks, for the help and quick response.
Bob

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

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

--
Good 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

 

[ralph]

dddddddddddddddddddddddddddddd

 

[ralph]

kan ik niks aan doen

 

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

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

Answers/posts based on Access 2000

Message posted via AccessMonster.com