Monthly Count

[davie303]

I have a filed in my Mdb called[DateInitiated]and i want to return a count of all records in my Mdb initiated per month.
can any one help

Count of records for each month

Thanks

Davie

 

[araskas]

SELECT
Year([DateInitiated]) AS [YEAR],
Month([DateInitiated]) AS [MONTH],
Count([DateInitated]) AS [Count]
FROM myTable
GROUP BY
Year([DateInitiated],
Month([DateInitiated]);