Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax for calculated field to return specific records

Status
Not open for further replies.

cft

Technical User
Dec 4, 2001
7
0
0
US
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".
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top