Numeric total of the occurrence of a word in a set of fields
I am simply trying to caculate a numeric total from the existence of a particular string (a word) in a set of fields. In other words, I have four fields in my database. If a particular word appears in any of those fields, a number gets incremented that appears in another field. I've tried many things, all to no effect. Help?