Word Count in Fields

[davefilm]

Hello,

I am trying to do a count of how many times a Certain word appears in a text field. I would like to count how many times "Suit 1" and "Suit 2" appears in my database, all references would be entered in the same fields, among different records.

Thanks,

Dave

[LaRetta]

PatternCount ( yourField ; "Suit 1" ) ... will tell you how many times it appears in the field. So create a calculation (result is number) with it.

Do you want result for found set or all records? Then create a Summary field with "Total of" and point to the above calc. This will produce total 'count' of Suite 1 for that set of records.

[davefilm]

thanks!!