I have a database with three fields.
Manager, Employee Name, Time Not =Entered (date field)
Each manager will have many employees who do not enter their time. I know how to count the employees by Manager and I did that by created this field: Count (Employee Name)
But, I now can’t figure out how to only count each employee 1 time as oppose to counting each instance of the employee for a particular manager.
Example: Manager Smith will have 5 different employees, but the total record count will be 25 for Manager Smith for his group of 5 employees. I only want my field to show 5 as that is the actual total employees Manager Smith has. I can't figure out how summary this. Each time I try, I get 25.
Help a novice programmer.