AnsweredAssumed Answered

Count field with specific text

Question asked by AnitaWoods on May 28, 2011
Latest reply on Jun 9, 2011 by LaRetta_1

Title

Count field with specific text

Post

I am relatively new to FM, a casual user with a home-based business.  In essence, I simply want to count the number of times a field contains specific text. I have searched this forum and many places on the internet, but I still can't make it work. 

I have two text fields, Outcome_h and Outcome_p, that may contain "SAB" or "TAB".  I can count the total number of records (Count (Outcome_h) + Count (Outcome_p), now how do I JUST count the number of times "SAB" or "TAB" occurs?  I would appreciate VERY much specific help on how to make this work.

Outcomes