Need to count duplicate field entries only once not total

[TxBlueEyes]

I have several reports that are based on Teams, and their Team Leads assigned
to that team... The Team Leads each fill out a form with specific data, so
their name is on each record in the Team Lead Name Field...
However, I am trying to find a way to just get a count a Team Lead's name
only once that's been entered into the Team Lead Name Field.. Not get a total
count of each Team Lead Name in the Team Lead Name field.
I have had a bad case of Stuck on Stupid, and I cannot get the report to
count the Team Lead name field only once no matter how many times the same
Team Lead name is entered in the Team Lead Fieldthey enter a record..
So even though I only want 1 count per Team Lead Name per Team Lead, it's
giving me the total Count of the Team Lead Name entered in the Team Lead
Field..

 

[Marshall Barton]

I have several reports that are based on Teams, and their Team Leads assigned
to that team... The Team Leads each fill out a form with specific data, so
their name is on each record in the Team Lead Name Field...
However, I am trying to find a way to just get a count a Team Lead's name
only once that's been entered into the Team Lead Name Field.. Not get a total
count of each Team Lead Name in the Team Lead Name field.
I have had a bad case of Stuck on Stupid, and I cannot get the report to
count the Team Lead name field only once no matter how many times the same
Team Lead name is entered in the Team Lead Fieldthey enter a record..
So even though I only want 1 count per Team Lead Name per Team Lead, it's
giving me the total Count of the Team Lead Name entered in the Team Lead
Field..

If you group on the team lead field and add a group header
or footer, then you can count the groups by adding a text
box (named txtGrpCnt) to the group header or footer. Set
the text box's ControlSource to =1 and RunningSum to Over
All. You can then use another text box in the report footer
with the expression =txtGrpCnt