Count in each month

[Kappa]

I've a column, say A1, with different dates between Jan 2005 to Dec
2005.

How can I count how many times Month Jan (e.g. 01-Jan-2005) has come,
how many times Month Feb date has come and so on.

There must be some function which can give me this.

 

[Jeff Boyce]

Create a new query.

Add the table (this is an MS Access newsgroup after all).

Add the date-related field.

Add a new field that determines which month the date is in -- for example:
WhatMonth: Month([YourDateField])

Change the query to a Totals query, GroupBy your new WhatMonth field and
Count your table's rowID field.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP