Link to home
Start Free TrialLog in
Avatar of mkelly2384
mkelly2384Flag for United States of America

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?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mkelly2384

ASKER

I got it.  Thanks for the help!