Access ACCESS group by date, month, and sum value.

[actuarygirl]

How can I make

Date______ Premium
1/1/2007 _______1
1/5/2007 _______3
2/1/2007 _______1
3/1/2007 _______0
1/1/2008 _______5

Look like.................

Year _Month _Total Premium
2007___ 1______ 4
2007___ 2______ 1
2007 ___3______ 0
2008___ 1______ 5


in Access 2007? Please help!

 

[fmarckus]

You could use a GROUP BY query grouping by Month(<your date field>) and Year(<your date field>), and summing by <your premium field>

 

[actuarygirl]

Thanks! This helps