wish to tabulate service counts as monthly totals per employee

  • Thread starter Thread starter Rocky
  • Start date Start date
R

Rocky

This is probably so easy, I'm going to be embarressed to post... but I'm
going around in circles and not getting anywhere. Thanks if you can help.

Here's the data I have in my linked CSV file
ServiceCode (this is number which could be counted)
Begin Date (date which I should be able to group by month)
Emp #
EmpName

So the end result of having a report which shows each empolyee per page with
Months as column headers and total counts beneath.

Thanks for any pointers you may be willing to share.
 
Try this --
TRANSFORM Count([ServiceCode]) AS CountOfServiceCode
SELECT EmpName
FROM [Linked CSV]
GROUP BY EmpName
PIVOT Format([Begin Date], "yyyy mm");
 
Karl,
Thanks a million. That worked like a charm. I REALLY APPRECIATE IT!
Hopefully one day I'll get proficient enough to help others here.
 
Back
Top