Counting occurances of months

[Gally]

Hi

I have a table with a column which has dates in it.

Eg

Column a

01/07/2004
19/07/2004
28/09/2004
06/10/2004
28/10/2004
17/11/2004
24/11/2004
30/11/2004
16/12/2004
10/01/2005
13/01/2005
19/01/2005

I need to count how many records are in each month

Ie 07/2004 = 2
09/2004 = 1
10/2004 = 2
11/2004 = 4
etc

I am using a group by and a count in a query but I think I need some sort of criteria which tells it only to work it out on the month & Year.

Sorry if this is an easy one!! I am not the best at Access but I am a tryer!!!!

TA
IAIN

 

[KeithG]

look up the datepart function in Access help. This will let you exact a certain part of a date.

 

[boblarson]

And go delete your multiple posts. Just go into the post, click on EDIT and select DELETE.