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?