AnsweredAssumed Answered

add up fields with an X in them

Question asked by cmahan on Oct 16, 2015
Latest reply on Oct 16, 2015 by erolst

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.

 

Connie

Outcomes