How to count the number of times a word occurs in a field...

[rbasram]

I have a field named HISTORY(Type Text) in the table TIP. Is there a query that can count the number of times the word "VALIDATED" occurs in this field and give only the records that have only count=1 (i.e VALIDATED occurs only once)

Any suggestions will be appreciated..

Thank-you

 

[GGleason]

rsoor,

I would create a function (you could call it StrFound) that would return the number of times the text string occurs. You could use the function within the query (in design view it would be Expr1: StrFound([HISTORY],"Validated&quot) and have a where clause in your SQL statement that would look for values of 1 (e.g, "WHERE Expr1 = 1&quot.

HTH,
GGleason