mkelly2384
asked on
Count records and give summary in an Access 2007 Report
I want to create a report that looks like this:
Employee LC CC Advising Signature TOTALS
Dan Poff 28 45 31 17 121
Nicole Barnett 31 42 30 9 112
Megan Gilmore 10 11 29 8 58
Shanna Conner 32 46 30 5 113
Jodi Bontreger 29 62 34 7 132
TOTALS 130 206 154 46 536
The tables hold one record for each time a student comes in to see an employee in our office. So those numbers in the report would have to be a count of all students that came to see a certain employee for a certain reason (LC, CC, Advising, etc.)
I can create a report that lists all employees and every student they saw with a total for each employee, but I just want the total count, not a listing of all of the students. How would I create this?
Employee LC CC Advising Signature TOTALS
Dan Poff 28 45 31 17 121
Nicole Barnett 31 42 30 9 112
Megan Gilmore 10 11 29 8 58
Shanna Conner 32 46 30 5 113
Jodi Bontreger 29 62 34 7 132
TOTALS 130 206 154 46 536
The tables hold one record for each time a student comes in to see an employee in our office. So those numbers in the report would have to be a count of all students that came to see a certain employee for a certain reason (LC, CC, Advising, etc.)
I can create a report that lists all employees and every student they saw with a total for each employee, but I just want the total count, not a listing of all of the students. How would I create this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER