Hello all, I have a weird problem I'm trying to solve. I have a table with a text field. In that text field, the same word may appear more than once (on purpose.) I'm not worried about misspellings or variations at this time.
Here is an example...
The text field is for which college degrees a person has.
A sample record might be...
"Bachelors of Science in Geology, Bachelors of Arts in basket weaving, Associates in Science."
Now, I want to count how many times "Bachelors" and "Associates" appear in this field.
So there would be two additional calculated fields called "Total Bachelors" and "Total Associates." In this case, they would be set to "2" and "1" respectively.
Is this something that is even possible? If so, how can I perform this in a query?
Thanks so much for any help.
Inchman
Here is an example...
The text field is for which college degrees a person has.
A sample record might be...
"Bachelors of Science in Geology, Bachelors of Arts in basket weaving, Associates in Science."
Now, I want to count how many times "Bachelors" and "Associates" appear in this field.
So there would be two additional calculated fields called "Total Bachelors" and "Total Associates." In this case, they would be set to "2" and "1" respectively.
Is this something that is even possible? If so, how can I perform this in a query?
Thanks so much for any help.
Inchman