I want to run a query that returns a list of months and how many new records
were created in each month.
For example:
January, 30
Febuarary, 40
March, 24
etc.
The database contains a date field with dates stored in ODBC format
(createODBCDate()).
I've tried this query, but it doesn't give me what I want:
SELECT DateCreated, Count(DatePart('M', DateCreated)) AS MonthCreatedCount
FROM Table1
GROUP BY DateCreated
ORDER BY Count(DatePart('M', DateCreated)) DESC
What I get is a day by day count instead of a month by month count.
So, what would be the proper query? Or proper output? And/OR?
TIA.
Best,
H.
=========================
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=========================
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
