I am creating a Data Entry Form for Employee evaluations. On the form I have a calculated field called "Record". This field is to show the cumulative number of entries within a given month.
Each Supervisor has Employees whom they evaluate 12 times a month. The form confirms the Employee ID and tells the Supervisor which number evaluation they are about to enter. If a Supervisor "pulls" an employee record and it shows 12 records,they are finished with that employee's audits for the month. What I need to build is the Expression that will: match the EmpID to the number of Employee-specific records within a Calendar month. The field is set up to read,"Record [Calculated Field] of 12".
Each Supervisor has Employees whom they evaluate 12 times a month. The form confirms the Employee ID and tells the Supervisor which number evaluation they are about to enter. If a Supervisor "pulls" an employee record and it shows 12 records,they are finished with that employee's audits for the month. What I need to build is the Expression that will: match the EmpID to the number of Employee-specific records within a Calendar month. The field is set up to read,"Record [Calculated Field] of 12".