2 Replies Latest reply on Aug 26, 2012 10:47 AM by GuyStevens

    Conditional Summary

    JamesPyles

      Title

      Conditional Summary

      Post

      I'm somewhat new to FM - so please forgive me if they has been answered in the past.

      My hope is to create a conditional summary field for a martial arts database.  

      I have two tables - one labeled Students with the fields being Student Name and Current Rank.  My second table is labled Attendance in which I have the field date (and possible an Attendance field in which the number 1 would be automatically inserted for counting purposes - if that is needed).  My hope is to be able to count the number of attendances a student has based on their current rank.  For instance, it would count how many times the student has attended classes as a white belt, but then when their rank changes to blue belt, I want it to add only the classes they have attended as a blue belt.  What would be the best way to go about this?