need help with a sql

[nj.astrology]

I have data as shown in xls which I uploaded into a table in access.


I need to find the sum of counts of hit rate, sum of counts for dec, jan, feb, march ( each month) for each business ( na cards, canada cards). how can I write this sql ?

[orange]

What have you tried? What result?

[Tyork]

Try the following:

SELECT YEAR(Proc_Date) & Month(Proc_Date), Business, SUM(HitRate), SUM(Count)
FROM [TableName]
GROUP BY YEAR(Proc_Date) & Month(Proc_Date), Business