Display total record count where date column is between two dates
I have a database which contains a column called 'StagingDate' which is date formatted yyyy-mm-dd. I'd like to display a table which shows a total count of all records with the StagingDate divided up into months, so the table would have a row for each month January-December and in the Date column it would show the total records with a date in January, the total with a date in February and so on. How would I set this up? Oh, and the client would like this working for a presentation on Tuesday this week, so I'm desperately trying to get it up and running by Monday evening (GMT)!! Any help would be appreciated.