Count in a query by Month 1

[LimitedTech]

I am attempting to setup a query that will count the number of records in a given month.

The Field Names used are as follows;

ID
Date
CustomerCode

Currently it groups by each day instead of by month.

I know this is simple but I've looked in the faqs and can't find it.

Thanks for any help.

 

[PWise]

Select count(*) as cstar, CustomerCode,month(date) as m,year(date) as y
from tablename
group by CustomerCode,month(date),year(date)

 

[LimitedTech]

Worked Great Thanks!