Query - Tally date

[phillsheen]

Hi,
This one sounds really simle but Im not sure of hte best step forward.

I have a membership database. Everytime we have a new member we enter the date the member joined in a simple short format. So for example

Joined Date
1/1/2008
4/1/2008
10/1/2008
3/2/2008
6/2/2008

I would like a query that would tally up the members joined per month so the output would be something like
Month - Tally
Jan - 3
Feb - 2

Sounds easy but Im not sure on where to start ont his one.

Any help would be fantastic!

Phill

 

[Kiwiman]

Howzit

Try...

SELECT Format([yourdate],"mmm-yy") AS Mth, Count(yourtable.yourpk) AS Members
FROM yourtable
GROUP BY Format([yourdate],"mmm-yy");

This will group by mth-Year eg Jan-08, Feb-08 etc

 

[phillsheen]

Works a treat!
Cheers!