wish to tabulate service counts as monthly totals per employee

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.


--
Rocky''''''''s Curious Coding

Try this --
TRANSFORM Count([ServiceCode]) AS CountOfServiceCode
SELECT EmpName
FROM [Linked CSV]
GROUP BY EmpName
PIVOT Format([Begin Date], "yyyy mm");

--
Build a little, test a little.


"Rocky" wrote:

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.


--
Rocky''''''''s Curious Coding

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.
--
Rocky''''''''s Curious Coding