Writing SQL [RESOLVED]

[freeze_sr]

I'm using MS Access 2002

I have a table called Table 1

In table1 there are colums called "days", "month", & "spent"

How do i write an sql to view the total sum spent for each month. (the "spent" in my database is filled for each day - so 30days = 30spents * 12 months)


The output should be just two columns - month & spent. And it should have only 12 rows - January to december.


I'm using this for now

SELECT Sum(spent) AS January
FROM table1
WHERE (((table1.month)="January"));

But i want all the months in one query.
Is there a way to get what i want, or is making 12 queries then combining them the only way?