Generate monthly progression statistics based on table.

[djmc]

Hi. I have a table in MS Access with something like this..

Date Code
---- ----
05/01/2002 A
05/02/2002 B
05/02/2002 A
05/06/2002 C
05/31/2002 C
06/01/2002 A
06/05/2002 B
06/15/2002 B
06/18/2002 C
06/30/2002 A

I want to generate a report of some sort based on a SQL query maybe or something that would give me the monthly count in a table. Like this:

A B C Total
---------------------
May 2 1 2 5
June 2 2 1 5

How would I be able to do something like this?
Or maybe just even showing the Total is fine. So that I can make it create a bar graph showing the progression throughout the year.

Thanks.

 

[AWithers]

Looks like a cross tab query to me. Have a look at the cross-tab query wizard and then point a report at the resultant query

Andy