davefilm Posted February 2, 2012 Share Posted February 2, 2012 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 Link to comment Share on other sites More sharing options...
LaRetta Posted February 2, 2012 Share Posted February 2, 2012 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. Link to comment Share on other sites More sharing options...
davefilm Posted February 2, 2012 Author Share Posted February 2, 2012 thanks!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4479 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now