Count text values in a Access Field

Jun 29, 2016
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question