I have an Access Database. The payments table (tblPay) is:
pdID Autonumber (key)
pdStudent Long (links to Student Table)
pdClass Date/Time (holds date of class given)
pdPaid Integer (Amount paid for that class)

I have records going back to 2010.
I can easily obtain a list of records BETWEEN a range of dates, but that is not what I'm after.
I want to be able to produce a SQL statement that will give me the total paid in each Month or Year.
For example, the output I am after would be:

January 2010 1.050 €
February 2010 985 €
March 2010 1,190 €

or

2010 18.150 €
2011 21.410 €
2012 25.100 €

Unfortunately, after much searching on the web, I cannot find anything helpful. Maybe I was using the wrong search phrases but any guidance would be appreciated.