Calculating number of records matching specific criteria
Just a quick simple one for you guys this time. Basically I am attempting to generate a report of an inventory system that allows me to calculate the total number of items that have a matching field. For example, I want the field "totalFresnels" to count the number of times the word "fresnel" appears in the table Inventory::instrumentType. I am assuming I define the "totalFresnels" field as a calculation field and evaluate the number of times "fresnel" appears in the Inventory::instrumentType field, I am just not sure of the context of how to use it. Any advice?