I have a small database of about 500 records. Each record has a set of fields (letter1, letter2, letter3) etc and some of the fields have an X if the letter was signed. I would like to know how many letters each record has signed.
So, for instance, Record One has 4 fields marked with an X (out of 6) and that number would show up in a calculation or some other type of field with the number 4.
I've used Filemaker for a long time and I can do basic things but I've never been able to to do calculations (would love a recommendation for a book that walks you through it with really good basic examples). I was able to do summary fields at one time but I don't think that what's I want here.
Any help is appreciated.