count on report

  • Thread starter Sally R via AccessMonster.com
  • Start date
S

Sally R via AccessMonster.com

I have a database that contains names and addresses and they're grouped by
types. I have a report that displays them by type. I would like it to
display a count by each name then the total of each type in the footer. I'm
not to familiar with writing code...
This is what I would like it to display

Staff
---------------------
1. Adams
2. Johnson
3. Smith
4. Ray
TOTAL Staff = 4

Faculty
1. Tracy
TOTAL Faculty = 1
 
D

Duane Hookom

You don't need code. Add a text box to the detail section of the report:
Control Source: =1
Running Sum: Over Group

Add a text box to the group footer
Control Source: =Count(*)
 
Top