Counting different names in a report

[jujuluver]

I have written a report that shows all the production by date and shift at my place of employment. I now need to figure out how I can get the report to count the number of different machine operators that appear in this report. I need this to figure out production rate by operator. I can get it to count the number of records but not the number of operators. There may be 75 records with on 12 operators.

 

[stu_gnu]

Hi
You could try running a query and use the following coding -

Select[Your table name].[Your column name], count(*)As Numberof
FROM [Your table name]
GROUP BY [Your table name].[Your column name]

this should hopefully give you the figures that you require.

All the best
Stu