Quiz report

[arnonea@mqg-smtp3.usmc.mil]

Good morning everyone,

	I have a question about a Quiz report that I'm doing. I am searching 
our database for people that have completed courses from 1990 to 1997. I need 
to break the report by each course and then I need a total for each year. For 
example:
		COURSE   1990	1991	1992
		8000	    30	  15             100
		7000	    55           45            35

The problem is I can do this if I break it up and do one year at a time, but 
I'm searching through about 1 and 1/2 million records so I would like to do it 
just one time. Any help would be great.

Anthony P Arnone
Marine Corps Institute
E-mail: ArnoneA@mqg-smtp3.usmc.mil
Work Phone: (202) 433-2351 ext. 265