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@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------