count the instance of one word in different fields
I have a database of electrical panels (about 4000) for a large facility. each panel is one record with a number of fields (panel name, location, building, floor, voltage....) including 42 individual fields that contain the description of each breaker in each panel. I need to keep count of the instance of certain values i.e. "spare", "blank" for each panel.
I have tried playing with scripts to no avail so far...