Display totals for each month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make an Access report that lists across the top of the page
(columns) the names of the months of the year. In the rows, I need to count
the number of services delivered by staff members and I need the count to
display under the appropriate month name. So:
Row Header: Staff_Name
Column Header: Month_Name (Jan, Feb, Mar . . .)
Data: Total_Services_Count
I wouldn't think this would be hard to do, but evidently it is beyond my
knowledge level. Can this even be done using Access? If so, can anyone
PLEASE steer me in the right direction as to how to accomplish this.
I really appreciate any help that anyone has time to give.
Thanks!
SJ
 
Take a look at using a crosstab query.

Create a new query, select the Crosstab Query Wizard from the list that's
presented, and work through the wizard to create your query.
 
Thank you for the suggestions. Actually, i shouldn't have posted this
because fumbled around till i figured out that a crosstab query was what the
doctor ordered.
Thanks again though
 
Back
Top