Count the grouped names for a total

J

Jennifer

Hi, I have report that groups all the names of people that had services today. Group by Date, then Person.... How can I count the number of people that had services and list that as a number at the end of the report?
 
D

Duane Hookom

Try add a text box to the Person group header:
Name: txtPersonCount
Control Source: =1
Running Sum: Over All
Visible: No
Then add a text box to the report footer:
Control Source: =txtPersonCount

--
Duane Hookom
MS Access MVP


Jennifer said:
Hi, I have report that groups all the names of people that had services
Click to expand...
today. Group by Date, then Person.... How can I count the number of people
that had services and list that as a number at the end of the report?
 
J

Jennifer

what exactly to I type in the Text box...
The name of my column of data is "Client Name
and when you say the control Source: =1... are you referring to something else, or do I type in =1
----- Duane Hookom wrote: ----

Try add a text box to the Person group header
Name: txtPersonCoun
Control Source: =
Running Sum: Over Al
Visible: N
Then add a text box to the report footer
Control Source: =txtPersonCoun

--
Duane Hooko
MS Access MV


Jennifer said:
Hi, I have report that groups all the names of people that had service
Click to expand...
today. Group by Date, then Person.... How can I count the number of peopl
that had services and list that as a number at the end of the report
 
D

Duane Hookom

When I said Control Source: =1 it means to set the Control Source to the
value "=1"
 
Top