Jeff,

Table:

Create TABLE SomeTable1

(

Date datetime,

teacher varchar(5),

student varchar(3),

class char(1) )

Data:

INSERT INTO SomeTable1

(Date, teacher, student, class)

SELECT '2009/1/1', 'mary', 'a.d','a' UNION ALL

SELECT '2009/1/11', 'ram', 'a.e','b' UNION ALL

SELECT '2009/2/10', 'joe', 'a.e','c'UNION ALL

SELECT '2009/3/12', 'sara', 'a.d','a' UNION ALL

SELECT '2009/3/19', 'mary', 'a.f','b' UNION ALL

SELECT '2009/3/13','joe', 'a.d','c' UNION ALL

SELECT '2009/2/17', 'ram', 'a.e','c' UNION ALL

SELECT '2009/2/21', 'joe', 'a.f','b' UNION ALL

SELECT '2009/2/12', 'sara', 'a.f','a' UNION ALL

SELECT '2009/1/23', 'sara', 'a.d','b' UNION ALL

SELECT '2009/1/14', 'ram', 'a.e','a'

I need to make a query that returns something like this , where values under Jan , Feb , March represent no:of students attended the classes of respective teacher for that month.

Teacher Jan feb march

------ ------- ------- -------

joe 0 2 1

mary 1 0 1

ram 2 0 0

sara 1 1 1

Please help..............