AnsweredAssumed Answered

counting empty fields

Question asked by JimVanDyke on Jun 12, 2013
Latest reply on May 4, 2016 by RickWhitelaw


counting empty fields


     I'm finally switching from my Appleworks to Filemaker pro. I have a database of my photographic collection. As part of the database I have a field that indicates the value of each item in my collection. To make sure I have not accidently missed a value entry I have a summary field that checks all of the value fields and tells me how many are empty. In Appleworks I used the Count2 function. This function evaluated each value field and counted how many were empty by comparing each field to zero. So far as I can tell the Count function in Filemaker only lets me compare one field with another field rather than a string or numeric value. How do I go about counting empty fields?