looking for suggestions

I've got a single table which lists usernames, addressinfo and signup
dates

signup date is data type 'date'

I'm wondering if it's possible through the magic of SQL to run a query
like:

select * from table where signupdate > '01/01/1999' and < '04/01/1999';

then in the results, I would like to break this down by months. So I can
show total signups for january 1999, then February 1999 etc..

Kevin

--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------