AnsweredAssumed Answered

Help sum a count field

Question asked by bmccoy on Nov 13, 2012
Latest reply on Nov 14, 2012 by flusheddata

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.

Outcomes