Count records and give summary in an Access 2007 Report

mkelly2384
mkelly2384 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Hello mkelly2384,

You can use the crosstab query wizard to create a crosstab query returning those results, and then create a
report based on that crosstab query.

http://articles.techrepublic.com.com/5100-10878_11-6129954.html
http://office.microsoft.com/en-us/access/HP051874071033.aspx
http://allenbrowne.com/ser-67.html

Regards,

Patrick

Author

Commented:
I got it.  Thanks for the help!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial