February 2, 201214 yr 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
February 2, 201214 yr 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.
Create an account or sign in to comment