Count records for each month of year

[jzacharias]

I am trying to create a simple report that will display an officer name and then fields for each month of the year with the total record count for each month. I want it displayed as follows:

Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec

Name 12 15 15 20 15 Etc..
Name 9 10 Etc..

 

[jzacharias]

Didn't display formatting correctly, but I think it's understood what I am looking for.

 

[jzacharias]

I just learned about crosstab querys. I was able to make it work.