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

Joined
Jun 21, 2012
Messages
3
Reaction score
0
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!
 
Last edited:
Joined
Jun 21, 2012
Messages
2
Reaction score
0
You could use a GROUP BY query grouping by Month(<your date field>) and Year(<your date field>), and summing by <your premium field>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top