Group Total (1 Viewer)

[Joseph Teal]

I have an employee table with a name field and a code field AA, AB, AC, AD.

I need to have the report grouped by name and totaling the code field every time it changes.

EX. NAME1 AA
AA
TOTAL 2

NAME1 AB
AB
AB
TOTAL 3

NAME2 AA
TOTAL 1

 

[Richie]

Select group by name from sorting/grouping.
Add text box to group footer =Count([ControlName])