AnsweredAssumed Answered

Calculation field problem

Question asked by TaylorJansen on Aug 27, 2013
Latest reply on Aug 28, 2013 by philmodjunk


Calculation field problem


     There are  2 tables:

     Class Table & Registration Table


     Fields in Class Table:

     "Class ID" & "Class details" & "No. of Registration to this class" which is a calculation field I am having trouble with.

     Fields in Registration Table

     "Class ID" & "Status" . For Status the data may be "In Progress" & others" 


     So in the "No. of Registration to this class" field, I want to set up a calculation to look for the number of registration to this class with Registration Status "In Progress". The result maybe like" 10 students has registered for this class." Since a class will have a upper limit of students.