AnsweredAssumed Answered

Conditional Summary

Question asked by JamesPyles on Aug 26, 2012
Latest reply on Aug 26, 2012 by GuyStevens

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?

Outcomes