SQL Query Question - HELP!

Here's what I have to do:

How many total requests by month from 1/1/2002? 13 rows

Each request has an individual ID column and each row has a date that it was entered into the DB. I need the results of the query to look as such:

Month             Total
January 2002       12
February 2002      12
March 2002         12

etc...

I am trying to figure out how to take the date info and just turn it into a month and count the number of requests per month.

Any ideas gang?

Thanks! Received on Thu Mar 27 2003 - 00:02:23 CET